{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Collateral Tables","Note Balance","Cumulative Defaults"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":8,"defined_names":24,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Collateral Tables","index":0,"n_rows":241,"n_cols":31,"rows_kept":241,"cut":false,"hidden":false,"merged":[]}
[null,"CNHI CAPITAL AUSTRALIA RECEIVABLES TRUST SERIES 2017-1 (TERM DEAL)"]
[null,"COLLATERAL DATA TABLES"]
[]
[null,"OUTSTANDING RECEIVABLES",null,null,"2019-04-30",null,null,null,"2019-01-31",null,null,null,"2018-10-31",null,null,null,"2018-07-31",null,null,null,"2018-04-30",null,null,null,"2018-01-31",null,null,null,"2017-10-31"]
[]
[null,"Opening Balance",null,null,{"$f":"I13","v":230544996.13000011},null,null,null,259202455.34000018,null,null,null,283467876.49000013,null,null,null,308006527.8300001,null,null,null,379616885.59000003,null,null,null,413211906.91000003,null,null,null,449999902.83999997]
[null,"Principal Repayments - Scheduled",null,null,{"$f":"MIN(([3]Sheet1!$B$3+[4]Sheet1!$B$3+[5]Sheet1!$B$3),'[2]16 May 19'!D23)","v":55053713.039999992},null,null,null,24431755.949999996,null,null,null,17041956.469999991,null,null,null,21065667.00999999,null,null,null,69066943.859999925,null,null,null,28752953.190000005,null,null,null,29068085.999999996]
[null,"Principal Repayments - Unscheduled",null,null,{"$f":"'[2]16 May 19'!$H$23-'Collateral Tables'!E7","v":6413098.7499999627},null,null,null,4225703.2600000873,null,null,null,7032919.4199999645,null,null,null,3460781.3899999671,null,null,null,2543413.9000000507,null,null,null,4655843.9099999405,null,null,null,7719909.9299999438]
[{"$f":"SUM(AC9)","v":0},"Charge-Offs",null,null,{"$f":"'[2]16 May 19'!$H37","v":0},null,null,null,0,null,null,null,190545.26,null,null,null,12202.94,null,null,null,0,null,null,null,186224.22,null,null,null,0]
[null,"Reinstatements"]
[null,"New Receivables Purchased"]
[null,"Non Cash Change in Receivables"]
[null,"Closing Balance",null,null,{"$f":"E6-E7-E8-E9+E10+E11-E12","v":169078184.34000015},null,null,null,230544996.13000011,null,null,null,259202455.34000018,null,null,null,283467876.49000013,null,null,null,308006527.8300001,null,null,null,379616885.59000003,null,null,null,413211906.91000003]
[]
[null,"PORTFOLIO STATISTICS"]
[]
[null,"Summary"]
[null,"Number of contracts",null,null,{"$f":"[6]Summary!$B$4","v":2757},null,null,null,3136,null,null,null,3411,null,null,null,3664,null,null,null,3817,null,null,null,4136,null,null,null,4356]
[null,"Dollar value of contracts",null,null,{"$f":"[6]Summary!$B$6","v":61326.871360174053},null,null,null,73515.623765943761,null,null,null,75990.16574025208,null,null,null,77365.686814956192,null,null,null,80693.352850405878,null,null,null,91783.579688104655,null,null,null,94860.401035353672]
[null,"Number of contracts closed during the Quarter",null,null,{"$f":"[6]Summary!$B$19","v":379},null,null,null,275,null,null,null,251,null,null,null,152,null,null,null,319,null,null,null,219,null,null,null,259]
[null,"Dollar value of contracts closed during the Quarter",null,null,{"$f":"[6]Summary!$B$20","v":20529534.610000007},null,null,null,9816130.639999995,null,null,null,9299561.7100000028,null,null,null,6037872.459999999,null,null,null,13675265.359999986,null,null,null,7726571.4600000046,null,null,null,11324349.980000002]
[]
[{"$f":"SUM(AC23)","v":0},"Dollar Value of Recoveries from Collateral",null,null,{"$f":"[6]Summary!$C$16","v":2340},null,null,null,1800,null,null,null,1440,null,null,null,0,null,null,null,218294.43636363634,null,null,null,0,null,null,null,0]
[null,"Dollar Value of Recoveries from Other Sources",null,null,{"$f":"[1]Summary!$C$14","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[]
[null,"Average Term of Contracts (Months)",null,null,{"$f":"[7]Sheet1!$W$2759","v":55.57535003040001},null,null,null,54.529554227631905,null,null,null,54.119601323102223,null,null,null,53.909627887868069,null,null,null,53.612656471534798,null,null,null,53.056586732928359,null,null,null,52.791142825226352]
[null,"Average Term to Maturity (Months)",null,null,{"$f":"[7]Sheet1!$X$2759","v":22.324245108048785},null,null,null,23.733607956577114,null,null,null,26.144061733099758,null,null,null,28.742783944400294,null,null,null,31.280104809978692,null,null,null,32.807837730830528,null,null,null,35.248005455642144]
[null,"Average Residual / Balloon Payment *",null,null,{"$f":"[7]Sheet1!$AI$2759","v":3.922434770280607E-2},null,null,null,3.5186054167085742E-2,null,null,null,3.4984231038761755E-2,null,null,null,3.4894766372251113E-2,null,null,null,3.415862294888309E-2,null,null,null,3.2130613200688406E-2,null,null,null,3.1883835949619785E-2]
[null,"Average Seasoning (Months)",null,null,{"$f":"E26-E27","v":33.251104922351225},null,null,null,30.795946271054792,null,null,null,27.975539590002466,null,null,null,25.166843943467775,null,null,null,22.332551661556106,null,null,null,20.248749002097831,null,null,null,17.543137369584208]
[null,"Average Dollar Value of Individual Assets",null,null,{"$f":"E19/E18","v":22.244059252874159},null,null,null,23.442482068221864,null,null,null,22.277972952287328,null,null,null,21.115089196221668,null,null,null,21.14051685889596,null,null,null,22.191387738903448,null,null,null,21.776951569181282]
[null,"Weighted Average Interest Rate",null,null,{"$f":"[7]Sheet1!$AA$2759/100","v":2.6788837127800211E-2},null,null,null,2.6707041938835663E-2,null,null,null,2.6574534983816993E-2,null,null,null,2.6681749553637942E-2,null,null,null,2.6740005423353815E-2,null,null,null,2.7037203243209434E-2,null,null,null,2.7224187345666846E-2]
[]
[null,"Payment in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$34,'[8]Arrears Reporting'!$A$1:$D$7,3,FALSE),0)","v":2744},{"$f":"IFERROR(VLOOKUP($A$34,'[8]Arrears Reporting'!$A$1:$D$7,2,FALSE),0)","v":195519.78},{"$f":"F34/F$50","v":1.1563867968136486E-3},null,3128,148936.91999999998,6.4602104795203393E-4,null,3405,244573.95,9.4356339981111923E-4,null,3656,2564.3500000000099,9.0463513247169578E-6,null,3804,490793.4200000001,1.59345135785852E-3,null,4131,190928.48999999996,5.0295046729351557E-4,null,4347,271017.78999999992,6.5588088210398259E-4]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$35,'[8]Arrears Reporting'!$A$1:$D$7,3,FALSE),0)","v":8},{"$f":"IFERROR(VLOOKUP($A$35,'[8]Arrears Reporting'!$A$1:$D$7,2,FALSE),0)","v":97001.859999999986},{"$f":"F35/F$50","v":5.7371008790192983E-4},null,4,11616.369999999981,5.0386563122149681E-5,null,3,28877.220000000005,1.1140797243653158E-4,null,2,19298.430000000004,6.8079777641685756E-5,null,6,77740.689999999988,2.5239948824366516E-4,null,1,13341.020000000008,3.5143378775855515E-5,null,5,35820.54,8.6688063439086416E-5]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$36,'[8]Arrears Reporting'!$A$1:$D$7,3,FALSE),0)","v":4},{"$f":"IFERROR(VLOOKUP($A$36,'[8]Arrears Reporting'!$A$1:$D$7,2,FALSE),0)","v":148051.94},8.7564188471696573E-4,null,0,0,0,null,3,10324.189999999991,3.983060263243878E-5,null,0,0,0,null,5,98534.729999999981,3.1991117426701155E-4,null,3,20131.840000000007,5.3031992949183719E-5,null,2,107243.40000000002,2.5953608356053045E-4]
["4. 91 - 120 Days","91 - 120 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$37,'[8]Arrears Reporting'!$A$1:$D$7,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A$37,'[8]Arrears Reporting'!$A$1:$D$7,2,FALSE),0)","v":9447.4200000000055},5.5876043600055232E-5,null,2,15837.970000000005,6.8697955999310852E-5,null,0,0,0,null,3,36625.689999999995,1.2920578674914553E-4,null,1,3775.0599999999981,1.225642854583784E-5,null,1,3861.3100000000036,1.0171597066865854E-5,null,1,25089.710000000014,6.0718748856055268E-5]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$38,'[8]Arrears Reporting'!$A$1:$D$7,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A$38,'[8]Arrears Reporting'!$A$1:$D$7,2,FALSE),0)","v":0},0,null,1,5325.0599999999977,2.3097703656067661E-5,null,0,0,0,null,2,11452.769999999979,4.0402355786526038E-5,null,1,0,0,null,0,0,0,null,1,0,0]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$39,'[8]Arrears Reporting'!$A$1:$D$7,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A$39,'[8]Arrears Reporting'!$A$1:$D$7,2,FALSE),0)","v":0},0,null,1,3951.9700000000057,1.7141859794569431E-5,null,0,0,0,null,1,10444.409999999982,3.6845127318574497E-5,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Total",null,null,{"$f":"SUM(E34:E39)","v":2757},{"$f":"SUM(F34:F39)","v":450021},{"$f":"SUM(G34:G39)","v":2.6616148130325997E-3},null,3136,185668.28999999998,8.053451305241315E-4,null,3411,283775.36000000004,1.0948019748800895E-3,null,3664,80385.649999999965,2.8357939882064876E-4,null,3817,670843.90000000014,2.1780184489150344E-3,null,4136,228262.65999999997,6.0129743608542069E-4,null,4356,439171.43999999994,1.0628237779596547E-3]
[null,"* Expressed as a % of Aggreg. Rec. closing bal.",null,null,null,"> 30 days",{"$f":"SUM(G35:G39)","v":1.5052280162189508E-3},null,null,"> 30 days",1.5932408257209762E-4,null,null,"> 30 days",1.5123857506897035E-4,null,null,"> 30 days",2.7453304749593181E-4,null,null,"> 30 days",5.8456709105651446E-4,null,null,"> 30 days",9.8346968791905093E-5,null,null,"> 30 days",4.0694289585567212E-4]
[]
[" 0 - 30 Days","Account Balances in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$44,'[8]Arrears Reporting'!$A$1:$D$7,3,FALSE),0)","v":2744},{"$f":"IFERROR(VLOOKUP($A$44,'[8]Arrears Reporting'!$A$1:$D$7,4,FALSE),0)","v":168108309.51999983},{"$f":"F44/F$50","v":0.99426374949680285},null,3128,230291452.75999966,0.99890024344810757,null,3405,259010982.71999982,0.99926130090184206,null,3656,282794384.02999949,0.99762409600572943,null,3804,307220774.93999904,0.99744890832172972,null,4131,379431680.77000087,0.9995121270232431,null,4347,412348242.53000063,0.99790987537978171]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$45,'[8]Arrears Reporting'!$A$1:$D$7,3,FALSE),0)","v":8},{"$f":"IFERROR(VLOOKUP($A$45,'[8]Arrears Reporting'!$A$1:$D$7,4,FALSE),0)","v":322182.38},{"$f":"F45/F$50","v":1.9055230647149752E-3},null,4,164754.28,7.1462960708589137E-4,null,3,126660.98000000001,4.8865655934415006E-4,null,2,386487.83999999985,1.3634272947807362E-3,null,6,379940.5,1.233546907842499E-3,null,1,12202.940000000002,3.2145408866716198E-5,null,5,283384.2,6.8580840789208522E-4]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$46,'[8]Arrears Reporting'!$A$1:$D$7,3,FALSE),0)","v":4},{"$f":"IFERROR(VLOOKUP($A$46,'[8]Arrears Reporting'!$A$1:$D$7,4,FALSE),0)","v":499372.13},2.9534982999096506E-3,null,0,0,0,null,3,64811.640000000007,2.5004253881386111E-4,null,0,0,0,null,5,358218.15999999992,1.163021324657491E-3,null,3,134159.14000000001,3.5340667154857923E-4,null,2,207466.89000000004,5.0208352308005319E-4]
["4. 91 - 120 Days","91 - 120 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$47,'[8]Arrears Reporting'!$A$1:$D$7,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A$47,'[8]Arrears Reporting'!$A$1:$D$7,4,FALSE),0)","v":148320.30999999997},{"$f":"F47/F$50","v":8.7722913857261572E-4},null,2,38009.410000000003,1.6486764249078417E-4,null,0,0,0,null,3,128825.05999999998,4.5446087787850216E-4,null,1,35391.29,1.1490435040238447E-4,null,1,38842.74,1.0232089634166452E-4,null,1,356437.59,8.6260241788636003E-4]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$48,'[8]Arrears Reporting'!$A$1:$D$7,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A$48,'[8]Arrears Reporting'!$A$1:$D$7,4,FALSE),0)","v":0},{"$f":"F48/F$50","v":0},null,1,26802.450000000004,1.1625691491862459E-4,null,0,0,0,null,2,148341.91,5.2331118374618856E-4,null,1,12202.940000000002,3.9619095367794555E-5,null,0,0,0,null,1,16375.699999999995,3.9630271359936141E-5]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$49,'[8]Arrears Reporting'!$A$1:$D$7,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A$49,'[8]Arrears Reporting'!$A$1:$D$7,4,FALSE),0)","v":0},{"$f":"F49/F$50","v":0},null,1,23977.23000000001,1.0400238739720787E-4,null,0,0,0,null,1,9837.6499999999942,3.470463786519055E-5,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Total",null,null,{"$f":"SUM(E44:E49)","v":2757},{"$f":"SUM(F44:F49)","v":169078184.33999982},{"$f":"SUM(G44:G49)","v":1},null,3136,230544996.12999964,1.0000000000000002,null,3411,259202455.33999979,1,null,3664,283467876.48999947,1,null,3817,308006527.82999909,0.99999999999999989,null,4136,379616885.59000087,1.0000000000000002,null,4356,413211906.91000056,1.0000000000000002]
["NSW",null,null,null,null,"> 30 days",{"$f":"SUM(G45:G49)","v":5.7362505031972408E-3},null,null,"> 30 days",1.099756551892508E-3,null,null,"> 30 days",7.3869909815801123E-4,null,null,"> 30 days",2.3759039942706172E-3,null,null,"> 30 days",2.5510916782701689E-3,null,null,"> 30 days",4.8787297675695996E-4,null,null,"> 30 days",2.0901246202184344E-3]
[null,null,null,null,null,">90 days",{"$f":"SUM(G47:G49)","v":8.7722913857261572E-4},null,null,">90 days",3.8512694480661664E-4,null,null,">90 days",0,null,null,">90 days",1.0124766994898812E-3,null,null,">90 days",1.5452344577017901E-4,null,null,">90 days",1.0232089634166452E-4,null,null,">90 days",9.022326892462962E-4]
[]
["VIC","Geographic Distribution"]
["NSW","New South Wales",null,null,{"$f":"F55/F$63","v":0.32159306661738435},{"$f":"IFERROR(VLOOKUP($A$55,'[8]Geographic '!$A$1:$C$10,3,FALSE),0)","v":54374371.800000019},null,null,0.32861234306417303,75759931.359999999,null,null,0.32940997197731231,85383873.549999908,null,null,0.33642464243515169,95365578.98999998,null,null,0.34323414336318814,105718356.73000002,null,null,0.33285587732383132,126357711.49999988,null,null,0.33195637419004981,137168326.38999993]
["VIC","Victoria",null,null,{"$f":"F56/F$63","v":0.16952528205744988},{"$f":"IFERROR(VLOOKUP($A$56,'[8]Geographic '!$A$1:$C$10,3,FALSE),0)","v":28663026.890000012},null,null,0.15949989480259649,36771902.630000018,null,null,0.15682064128860596,40648295.270000026,null,null,0.16003502958332694,45364790.000000007,null,null,0.16474594459896272,50742826.370000042,null,null,0.15885043223585349,60302306.360000007,null,null,0.15904321078606742,65718548.409999982]
["QLD","Queensland",null,null,0.11314781977744533,{"$f":"IFERROR(VLOOKUP($A$57,'[8]Geographic '!$A$1:$C$10,3,FALSE),0)","v":19130827.930000003},null,null,0.10137109350584979,23370598.360000007,null,null,0.10597207952358897,27468223.209999986,null,null,0.11099705977128585,31464100.829999998,null,null,0.11575269167567111,35652584.649999999,null,null,0.10786738352367618,40948280.190000013,null,null,0.11059645045502933,45699770.18999999]
["SA","South Australia",null,null,0.1938958180676664,{"$f":"IFERROR(VLOOKUP($A$58,'[8]Geographic '!$A$1:$C$10,3,FALSE),0)","v":32783552.870000008},null,null,0.19968500875222178,46036379.569999985,null,null,0.19128336687614966,49581118.359999999,null,null,0.18357148215288413,52036618.229999989,null,null,0.17755426125313886,54687871.510000005,null,null,0.18890631468762331,71712026.849999994,null,null,0.18235812797236814,75352549.800000027]
["NT","Northern Territory",null,null,1.2173832526264279E-3,{"$f":"IFERROR(VLOOKUP($A$59,'[8]Geographic '!$A$1:$C$10,3,FALSE),0)","v":205832.95},null,null,1.1412866660165234E-3,263117.93,null,null,1.0292118940388433E-3,266774.25,null,null,9.5387997168539418E-4,270394.32999999996,null,null,8.8952182906726796E-4,273978.52999999997,null,null,8.6900025399894957E-4,329887.17,null,null,8.0685162848566404E-4,333400.7]
["ACT","Australian Capital Territory",null,null,3.3297968167665491E-4,{"$f":"IFERROR(VLOOKUP($A$60,'[8]Geographic '!$A$1:$C$10,3,FALSE),0)","v":56299.599999999991},null,null,2.9136928203864367E-4,67173.729999999981,null,null,3.0975412595796452E-4,80289.03,null,null,3.4659627474037949E-4,98248.909999999989,null,null,3.6088566298617727E-4,111155.14,null,null,3.3939870667174042E-4,128841.47999999998,null,null,3.4265033904465526E-4,141587.19999999998]
["TAS","Tasmania",null,null,8.446393279976476E-3,{"$f":"IFERROR(VLOOKUP($A$61,'[8]Geographic '!$A$1:$C$10,3,FALSE),0)","v":1428100.84},null,null,7.4239079517253665E-3,1711544.8300000008,null,null,8.0210615183904811E-3,2079078.8400000003,null,null,8.9376346673601878E-3,2533532.3199999994,null,null,9.8188276765004186E-3,3024263.02,null,null,9.1249761575180315E-3,3463995.0299999984,null,null,9.3074462901130087E-3,3845947.63]
["WA","Western Australia",null,null,0.19184125726577458,{"$f":"IFERROR(VLOOKUP($A$62,'[8]Geographic '!$A$1:$C$10,3,FALSE),0)","v":32436171.460000005},null,null,0.20197509597537827,46564347.719999962,null,null,0.20715391279595574,53694802.829999946,null,null,0.19873367514356532,56334612.879999951,null,null,0.18764372394048534,57795491.879999928,null,null,0.20118661711082714,76373837.009999961,null,null,0.20558888833884209,84951776.589999974]
[null,"Total",null,null,{"$f":"SUM(E55:E62)","v":1},{"$f":"SUM(F55:F62)","v":169078184.34000003},null,null,0.99999999999999978,230544996.13,null,null,0.99999999999999989,259202455.33999988,null,null,0.99999999999999989,283467876.48999995,null,null,1.0000000000000002,308006527.82999998,null,null,1.0000000000000002,379616885.58999979,null,null,1.0000000000000002,413211906.90999985]
["AG",null,null,null,null,null,{"$f":"E13-F63","v":0},null,null,null,0,null,null,null,2.9802322387695313E-7,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["CE","Top Industry Distribution"]
["AGRICULTURAL MACHINERY","Agricultural",null,null,{"$f":"F66/F$69","v":0.95830169736254922},{"$f":"IFERROR(VLOOKUP($A$66,'[8]Top Industry'!$A$1:$C$4,3,FALSE),)","v":162027911.04000014},null,null,0.96326981907156606,222077036.70999965,null,null,0.9627593841758243,249549596.27999973,null,null,0.9613595325663421,272514545.23999995,null,null,0.95983496535882473,295635434.96999896,null,null,0.96381231354171926,365879428.76000106,null,null,0.96263243066864712,397771182.33000034]
["CONSTRUCTION EQUIPMENT","Construction",null,null,{"$f":"F67/F$69","v":4.1698302637450689E-2},{"$f":"IFERROR(VLOOKUP($A$67,'[8]Top Industry'!$A$1:$C$4,3,FALSE),)","v":7050273.3000000017},null,null,3.6730180928433998E-2,8467959.4200000018,null,null,3.724061582417576E-2,9652859.0600000042,null,null,3.8640467433657864E-2,10953331.249999993,null,null,4.0165034641175199E-2,12371092.860000001,null,null,3.6187686458280771E-2,13737456.830000002,null,null,3.7367569331352955E-2,15440724.58]
["MOTOR VEHICLE - AG","Motor Vehicle AG",null,null,{"$f":"F68/F$69","v":0},{"$f":"IFERROR(VLOOKUP($A$68,'[8]Top Industry'!$A$1:$C$4,3,FALSE),)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,"Total",null,null,{"$f":"SUM(E66:E68)","v":0.99999999999999989},{"$f":"SUM(F66:F68)","v":169078184.34000015},{"$f":"F63-F69","v":0},null,1,230544996.12999964,3.5762786865234375E-7,null,1,259202455.33999974,0,null,1,283467876.48999995,0,null,0.99999999999999989,308006527.82999897,1.0132789611816406E-6,null,1,379616885.59000105,-1.2516975402832031E-6,null,1,413211906.91000032,-4.76837158203125E-7]
["COMBINE"]
["40-100 HP TRACTOR","Collateral Types"]
["100<140 HP TRACTOR","100<140 HP TRACTOR",null,null,{"$f":"IFERROR(F72/F$101,0)","v":0.10082049293669396},{"$f":"IFERROR(VLOOKUP($A$72,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":17046545.890000008},null,null,8.9797960344046093E-2,20702470.420000002,null,null,9.2116445689838858E-2,23876808.899999991,null,null,9.5103258237978924E-2,26958718.659999982,null,null,9.9169757878829229E-2,30544932.789999977,null,null,9.4296612028637719E-2,35796586.179999985,null,null,9.6241139703318532E-2,39767984.85999997]
["4 EWD TRACTORS","4 EWD TRACTORS",null,null,0.10697408681435097,{"$f":"IFERROR(VLOOKUP($A$73,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":18086984.369999997},null,null,0.10582103662854288,24396510.480000008,null,null,0.10942150151624412,28362321.860000007,null,null,0.1047440786859228,29691581.559999999,null,null,0.10249248414443907,31568354.170000006,null,null,0.10238381129857685,38866623.579999998,null,null,0.10267989716772899,42428556.110000014]
["40<60 HP TRACTOR","40<60 HP TRACTOR",null,null,9.0947927788706945E-3,{"$f":"IFERROR(VLOOKUP($A$74,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":1537731.05},null,null,8.2415772274172239E-3,1900054.3900000001,null,null,8.6645004849744585E-3,2245859.8000000003,null,null,9.1004680387162112E-3,2579690.3499999992,null,null,9.866392967090902E-3,3038913.44,null,null,9.3260630240344054E-3,3540330.9999999986,null,null,9.4955126519492943E-3,3923658.8899999997]
["4WD Vehicle","4WD Vehicle",null,null,0,{"$f":"IFERROR(VLOOKUP($A$75,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":""},null,null,2.9388341164340485E-4,67753.349999999977,null,null,2.6139162112151612E-4,67753.349999999977,null,null,2.390159718940504E-4,67753.349999999977,null,null,3.3652975062012331E-4,103653.35999999996,null,null,4.42855458704676E-4,168115.40999999997,null,null,4.0685035253985668E-4,168115.40999999997]
["60<100 HP TRACTOR","60<100 HP TRACTOR",null,null,5.3706670706492383E-2,{"$f":"IFERROR(VLOOKUP($A$76,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":9080626.3699999973},null,null,5.0102235849381456E-2,11550819.769999996,null,null,5.1211325226792878E-2,13274101.239999995,null,null,5.4112643308777644E-2,15339196.090000004,null,null,5.64994415625013E-2,17402196.820000015,null,null,5.4875845176442208E-2,20831797.440000016,null,null,5.5437609340210525E-2,22907480.270000022]
["BACKHOE","BACKHOE",null,null,1.5116889916798831E-3,{"$f":"IFERROR(VLOOKUP($A$77,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":255593.63},null,null,1.2253224088225627E-3,282491.95,null,null,1.2217446767030307E-3,316679.22000000003,null,null,1.1730823051892827E-3,332531.15000000002,null,null,1.2758902311865981E-3,392982.52,null,null,1.1276960173535464E-3,428092.44999999995,null,null,1.1257971569084569E-3,465192.79000000004]
["BALERS, WINDROWERS, MOWERS, RAKES","BALERS, WINDROWERS, MOWERS, RAKES",null,null,2.3715128215103468E-2,{"$f":"IFERROR(VLOOKUP($A$78,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":4009710.8199999994},null,null,2.4555028280934126E-2,5661038.8999999994,null,null,2.6236766820281473E-2,6800634.3800000018,null,null,2.9536972914443699E-2,8372782.9900000002,null,null,3.0056638913541569E-2,9257640.9900000021,null,null,3.0228916825353912E-2,11475407.260000004,null,null,3.1481946653665445E-2,13008715.209999993]
["COMBINES","COMBINES",null,null,0.29849527002556153,{"$f":"IFERROR(VLOOKUP($A$79,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":50469038.289999969},null,null,0.32606227058431508,75172024.909999937,null,null,0.31834960479738167,82516999.219999969,null,null,0.31892035732376584,90403676.459999904,null,null,0.31016726425593277,95533542.109999925,null,null,0.32788306994444938,124469949.85000002,null,null,0.32374721072386048,133776202.30000003]
["COMPACT TRACK LOADER","COMPACT TRACK LOADER",null,null,4.1419684197207293E-4,{"$f":"IFERROR(VLOOKUP($A$80,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":70031.649999999994},null,null,3.2949494144373298E-4,75963.41,null,null,3.1590780994952903E-4,81884.08,null,null,3.0971290675716883E-4,87793.66,null,null,3.0418891008606201E-4,93692.170000000013,null,null,2.6231612391328031E-4,99579.63,null,null,2.5521060317114467E-4,105456.06]
["CRAWLER  DOZER","CRAWLER  DOZER",null,null,1.0028379513411093E-3,{"$f":"IFERROR(VLOOKUP($A$81,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":169558.02000000002},null,null,9.4065554941697707E-4,216863.43000000002,null,null,8.9263344244368617E-4,231372.78,null,null,9.7861487317342012E-4,277405.88,null,null,9.4726248841399451E-4,291763.03000000003,null,null,8.8658869712002588E-4,336564.04000000004,null,null,8.4888867947457264E-4,350770.91000000003]
["CULTIVATORS,SEEDERS, HARROWS","CULTIVATORS,SEEDERS, HARROWS",null,null,1.6503829165734937E-2,{"$f":"IFERROR(VLOOKUP($A$82,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":2790437.47},null,null,2.0206308478598164E-2,4658463.3100000005,null,null,1.8054458333974826E-2,4679759.93,null,null,1.7285977870486715E-2,4900019.4400000004,null,null,1.6691041797781241E-2,5140949.830000001,null,null,1.8875246312775588E-2,7165362.2200000007,null,null,1.7547948858064526E-2,7251021.4100000011]
["DRILL","DRILL",null,null,8.8712030227612994E-4,{"$f":"IFERROR(VLOOKUP($A$83,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":149992.69000000003},null,null,9.2288721755654445E-4,212767.03000000003,null,null,9.2276286382496136E-4,239182.40000000002,null,null,8.4377250417804503E-4,239182.40000000002,null,null,7.7654977537363592E-4,239182.40000000002,null,null,7.8982514050712771E-4,299830.96000000002,null,null,7.8927800614185821E-4,326139.07]
["EXCAVATORS / GRADERS","EXCAVATORS / GRADERS",null,null,1.9924042378086017E-2,{"$f":"IFERROR(VLOOKUP($A$84,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":3368720.9099999997},null,null,1.7249108142679506E-2,3976695.5699999984,null,null,1.7518418311445919E-2,4540817.0399999982,null,null,1.79497202046437E-2,5088169.0699999975,null,null,1.8712562751855497E-2,5763591.4800000014,null,null,1.6767911390735246E-2,6365382.2999999998,null,null,1.7712056883186774E-2,7318832.7999999989]
["FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE","FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE",null,null,2.0447954379777911E-4,{"$f":"IFERROR(VLOOKUP($A$85,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":34573.03},null,null,1.4996217909889014E-4,34573.03,null,null,1.3338233989585479E-4,34573.03,null,null,1.2196454296019552E-4,34573.03,null,null,1.6880372752585505E-4,51992.650000000009,null,null,1.5199163206432436E-4,57698.590000000004,null,null,1.5321274373100081E-4,63309.33]
["FRONT END LOADER","FRONT END LOADER",null,null,1.0020301002245787E-3,{"$f":"IFERROR(VLOOKUP($A$86,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":169421.43},null,null,8.7764030187801928E-4,202335.58000000002,null,null,8.2154306648320673E-4,212945.98,null,null,8.7551849991988515E-4,248181.37000000002,null,null,8.6312144704520902E-4,265847.04000000004,null,null,8.0458884099766155E-4,305435.51,null,null,7.7093446406757118E-4,318559.30000000005]
["FRONTS","FRONTS",null,null,4.4809782702448899E-3,{"$f":"IFERROR(VLOOKUP($A$87,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":757635.66999999981},null,null,4.7219877606284781E-3,1088630.6499999999,null,null,4.8654156008891159E-3,1261127.6700000002,null,null,4.9754912883391766E-3,1410391.9500000004,null,null,5.0280918099722084E-3,1548685.0999999999,null,null,5.082388226754957E-3,1929360.3899999997,null,null,5.0360288636436658E-3,2080947.0899999999]
["HARVESTERS - Other","HARVESTERS - Other",null,null,3.73378483134473E-3,{"$f":"IFERROR(VLOOKUP($A$88,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":631301.56000000006},null,null,3.2882359744322073E-3,758086.35000000009,null,null,3.5078191632380244E-3,909235.34000000008,null,null,3.6363361618379484E-3,1030784.49,null,null,3.3907866737695695E-3,1044384.4299999999,null,null,3.3363086787659029E-3,1266519.1099999999,null,null,3.4514338433878403E-3,1426173.56]
["IRRIGATION EQUIPMENT","IRRIGATION EQUIPMENT",null,null,3.7863021920832627E-4,{"$f":"IFERROR(VLOOKUP($A$89,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":64018.11},null,null,3.1120532305781775E-4,71746.83,null,null,3.0609335816641196E-4,79340.150000000009,null,null,3.062091234985567E-4,86800.450000000012,null,null,3.056106332004555E-4,94130.07,null,null,2.6693040759372718E-4,101331.29000000001,null,null,2.6235052327185608E-4,108406.36000000002]
["MATERIALS HANDLING EQUIPMENT","MATERIALS HANDLING EQUIPMENT",null,null,7.941722376789972E-5,{"$f":"IFERROR(VLOOKUP($A$90,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":13427.719999999979},null,null,7.9889914373219739E-5,18418.219999999979,null,null,9.0217046629925582E-5,23384.479999999981,null,null,9.9928783291955395E-5,28326.599999999984,null,null,1.0793508252639681E-4,33244.709999999985,null,null,1.0046684288219832E-4,38138.909999999989,null,null,1.0408540819073653E-4,43009.329999999987]
["MINI EXCAVATOR","MINI EXCAVATOR",null,null,5.7772621808839064E-4,{"$f":"IFERROR(VLOOKUP($A$91,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":97680.899999999965},null,null,4.5870793890650266E-4,105752.81999999995,null,null,4.3895687581645257E-4,113778.69999999997,null,null,4.295331503084629E-4,121758.84999999995,null,null,4.2107416006320023E-4,129693.58999999995,null,null,3.62426475803805E-4,137583.20999999996,null,null,3.5194537613282041E-4,145428.01999999996]
["OTHER AG","OTHER AG",null,null,7.1822204901257104E-3,{"$f":"IFERROR(VLOOKUP($A$92,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":1214356.8},null,null,6.3147733173053956E-3,1455839.39,null,null,6.3594713554614296E-3,1648390.5900000003,null,null,6.5604923317143654E-3,1859688.8299999996,null,null,6.6715318161508601E-3,2054875.35,null,null,6.3795553936860892E-3,2421786.9499999997,null,null,6.3140171335098064E-3,2609027.0599999996]
["OTHER CE","OTHER CE",null,null,5.342121477858305E-4,{"$f":"IFERROR(VLOOKUP($A$93,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":90323.619999999981},null,null,1.1147593498627973E-3,257002.18999999992,null,null,1.0783822230130882E-3,279519.31999999989,null,null,1.0647550746747403E-3,301823.85999999993,null,null,1.0516634575315975E-3,323919.20999999996,null,null,9.1094132828824128E-4,345808.70999999996,null,null,9.2803739095428147E-4,383476.09999999992]
["OVER 140 HP TRACTOR","OVER 140 HP TRACTOR",null,null,0.25478287650270626,{"$f":"IFERROR(VLOOKUP($A$94,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":43078226.160000026},null,null,0.2394128452429147,55195433.480000064,null,null,0.23970842189167987,62133011.520000026,null,null,0.23502765634310008,66622790.660000049,null,null,0.2345171827003226,72232823.160000101,null,null,0.22779684656439819,86475529.439999938,null,null,0.22706452069987371,93825763.590000004]
["SKID STEER LOADER","SKID STEER LOADER",null,null,0,{"$f":"IFERROR(VLOOKUP($A$95,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":""},null,null,0,"",null,null,1.0700180275537663E-4,27735.129999999997,null,null,1.0490345632179255E-4,29736.759999999995,null,null,1.0303239422742203E-4,31734.649999999994,null,null,8.8849551430197202E-5,33728.789999999994,null,null,8.6442813971911598E-5,35719.19999999999]
["SKIDSTEER / UNILOADER","SKIDSTEER / UNILOADER",null,null,1.3352087017094351E-2,{"$f":"IFERROR(VLOOKUP($A$96,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":2257546.6299999994},null,null,1.17472340127168E-2,2708266.0199999996,null,null,1.1968124553183098E-2,3102167.2699999991,null,null,1.2959619006881008E-2,3673635.6800000016,null,null,1.3705092647678772E-2,4221258,null,null,1.2549249390200187E-2,4763906.9700000016,null,null,1.2906422348476946E-2,5333087.3900000006]
["SPRAYING EQUIPMENT","SPRAYING EQUIPMENT",null,null,7.5168991668626783E-2,{"$f":"IFERROR(VLOOKUP($A$97,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":12709436.630000003},null,null,8.1098158770955192E-2,18696774.699999992,null,null,8.0675771850117081E-2,20911358.149999999,null,null,7.8692893057979121E-2,22306907.289999999,null,null,8.144408190545073E-2,25085308.880000006,null,null,7.9538811855200023E-2,30194276.040000003,null,null,8.0296804509137051E-2,33179595.710000012]
["UNDER 40 HP TRACTORS","UNDER 40 HP TRACTORS",null,null,1.170314791186147E-3,{"$f":"IFERROR(VLOOKUP($A$98,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":197874.69999999998},null,null,1.0918221788603171E-3,251714.14,null,null,1.1427081954585626E-3,296192.77,null,null,1.2764263608288056E-3,361825.87,null,null,1.3896535992777438E-3,428022.38000000006,null,null,1.3443881170006732E-3,510352.43000000017,null,null,1.4368376372303211E-3,593718.41999999993]
["WHEEL LOADERS (OLD)","WHEEL LOADERS (OLD)",null,null,4.302093867635152E-3,{"$f":"IFERROR(VLOOKUP($A$99,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":727390.21999999974},null,null,3.5850086702118168E-3,826505.80999999982,null,null,3.609229082235591E-3,935521.03999999992,null,null,3.5705976724163518E-3,1012149.7399999998,null,null,3.536332517605525E-3,1089213.5,null,null,3.1312406405541414E-3,1188671.8199999998,null,null,3.0486826708853308E-3,1259751.9799999997]
["zzDo Not Use Z OVER 100 HP TRACTORS","Under 100 HP TRACTORS",null,null,0,{"$f":"IFERROR(VLOOKUP($A$100,[8]Collateral!$A$1:$C$29,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,8.258615775553338E-6,3135.1100000000006,null,null,1.8896793314575795E-5,7808.3800000000047]
[null,"Total",null,null,{"$f":"SUM(E72:E100)","v":0.99999999999999978},{"$f":"SUM(F72:F100)","v":169078184.34},{"$f":"F69-F101","v":0},null,0.99999999999999989,230544996.13000003,-3.8743019104003906E-7,null,1,259202455.33999997,-2.384185791015625E-7,null,0.99999999999999967,283467876.48999995,0,null,1.0000000000000002,308006527.82999998,-1.0132789611816406E-6,null,1,379616885.59000003,1.0132789611816406E-6,null,0.99999999999999978,413211906.91000009,0]
["$ 0 - $25,000"]
["$ 25,001 to $50,000","Contract Balance Distribution"]
["$0 - $25,000","$ 0 - $25,000",null,null,{"$f":"IFERROR(F104/F$115,0)","v":7.6398816561836294E-2},{"$f":"IFERROR(VLOOKUP($A$104,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":12917373.190000003},null,null,5.9172328478157919E-2,13641884.240000006,null,null,5.5731418597294177E-2,14445720.53999999,null,null,5.2053967958237232E-2,14755627.760000004,null,null,5.0258600066242699E-2,15479976.900000021,null,null,4.0996623598057294E-2,15563010.570000008,null,null,3.8358809620295593E-2,15850316.869999994]
["$25,001 - $50,000","$ 25,001 to $50,000",null,null,{"$f":"IFERROR(F105/F$115,0)","v":0.13482330342606516},{"$f":"IFERROR(VLOOKUP($A$105,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":22795679.350000001},null,null,0.10540211467568669,24299930.120000005,null,null,0.10603684303046988,27485010.069999959,null,null,0.10960190179113997,31068618.359999962,null,null,0.10568014531810704,32550174.619999979,null,null,9.3953108183182352E-2,35666186.320000023,null,null,8.6713470620787866E-2,35831038.550000012]
["$50,001 - $75,000","$ 50,001 to $75,000",null,null,0.12173307189418803,{"$f":"IFERROR(VLOOKUP($A$106,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":20582406.769999996},null,null,0.10018934003223984,23098151.009999987,null,null,9.5124077037224863E-2,24656394.329999998,null,null,9.2754234502926303E-2,26292845.890000001,null,null,9.5793753554096472E-2,29505101.419999976,null,null,8.1360079576011407E-2,30885660.020000018,null,null,8.3195884182223429E-2,34377529.950000048]
["$75,001 - $100,000","$ 75,001 to $100,000",null,null,0.11008142749257535,{"$f":"IFERROR(VLOOKUP($A$107,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":18612367.890000001},null,null,8.0024446766117738E-2,18449235.770000003,null,null,7.6761589560951735E-2,19896792.490000002,null,null,7.9442820889775251E-2,22519487.739999995,null,null,8.0557000511673235E-2,24812082.020000003,null,null,7.6326655556870918E-2,28974887.270000003,null,null,7.9629802868112123E-2,32903982.689999998]
["$100,001 - $125,000","$100,001 to $125,000",null,null,0.10153749176462208,{"$f":"IFERROR(VLOOKUP($A$108,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":17167774.750000004},null,null,8.5600733224640943E-2,19734820.710000008,null,null,8.6586143640347529E-2,22443341.030000005,null,null,8.2153514036083536E-2,23287882.170000002,null,null,7.7665658155151709E-2,23921529.699999999,null,null,6.5812941648183909E-2,24983703.939999975,null,null,6.4040503885488584E-2,26462298.73]
["$125,001 - $150,000","$125,001 to $150,000",null,null,8.4608400225265876E-2,{"$f":"IFERROR(VLOOKUP($A$109,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":14305434.690000001},null,null,9.0672533565693048E-2,20904098.899999999,null,null,7.8104851990866919E-2,20244969.409999993,null,null,7.6572044278060261E-2,21705714.789999988,null,null,7.4557891976480578E-2,22964317.43,null,null,5.9903763407828332E-2,22740480.099999994,null,null,5.245439915341283E-2,21674782.300000004]
["$150,001 - $200,000","$150,000 to $200,000",null,null,0.14775453827776777,{"$f":"IFERROR(VLOOKUP($A$110,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":24982069.060000006},null,null,0.14907186187906094,34367771.82,null,null,0.15216654243596342,39441941.420000024,null,null,0.13989792452337721,39656567.590000018,null,null,0.13216778581546343,40708540.800000012,null,null,0.1195332051667707,45376823.069999985,null,null,0.12003954765224985,49601770.389999971]
["$200,001 - $300,000","$200,001 to $300,000",null,null,0.1723176826964973,{"$f":"IFERROR(VLOOKUP($A$111,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":29135160.920000002},null,null,0.21575108570976023,49740333.219999969,null,null,0.21531843800164518,55811067.809999995,null,null,0.21887493383113105,62044012.709999956,null,null,0.22217250589497034,68430582.12000002,null,null,0.23446526808644327,89006974.850000009,null,null,0.22601890298466562,93393701.899999961]
["$300,001 - $400,000","$300,001 to $400,000",null,null,3.1401772089788935E-2,{"$f":"IFERROR(VLOOKUP($A$112,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":5309354.6100000003},null,null,6.9348421732756682E-2,15987931.619999995,null,null,8.6093639085047122E-2,22315682.640000004,null,null,9.337137363758298E-2,26467785.010000005,null,null,0.1033037121783394,31818217.700000003,null,null,0.13461409657944398,51101784.099999994,null,null,0.14234078202110143,58816905.969999962]
["$400,001 - $500,000","$400,001 to $500,000",null,null,1.2944207903244151E-2,{"$f":"IFERROR(VLOOKUP($A$113,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":2188583.1699999995},null,null,2.4490183629126673E-2,5646089.2899999982,null,null,2.3670800270591291E-2,6135529.5499999989,null,null,2.262868978110219E-2,6414506.6399999987,null,null,2.3608612262963027E-2,7271606.6900000004,null,null,5.1869825730741149E-2,19690661.699999999,null,null,6.1329037900932554E-2,25341888.700000003]
["$500,001+","$500,000+",null,null,6.3992876681490864E-3,{"$f":"IFERROR(VLOOKUP($A$114,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":1081979.94},null,null,2.0276950306759189E-2,4674749.43,null,null,2.4405656349597755E-2,6326006.0499999998,null,null,3.2648594770584134E-2,9254827.8300000001,null,null,3.4234334266512151E-2,10544398.429999998,null,null,4.1164432466466776E-2,15626713.649999999,null,null,4.5878859110730072E-2,18957690.859999999]
["$200,001 to $300,000","Total",null,null,{"$f":"SUM(E104:E114)","v":1},{"$f":"SUM(F104:F114)","v":169078184.34},{"$f":"F101-F115","v":0},null,1,230544996.13,0,null,0.99999999999999989,259202455.34,0,null,1.0000000000000002,283467876.48999989,0,null,1.0000000000000002,308006527.82999998,0,null,1.0000000000000002,379616885.58999997,0,null,1,413211906.90999997,0]
["0"]
["0 to 5","Residual / Balloon Payment Distribution"]
["0","0",null,null,{"$f":"IFERROR(F118/F$128,0)","v":0.86121324053958082},{"$f":"IFERROR(VLOOKUP($A$118,'[8]Residual '!$A$1:$C$12,3,FALSE),\"\")","v":145612371.04000014},null,null,0.87720375781204751,202234936.94999972,null,null,0.87730399008650073,227399348.30999988,null,null,0.87748422181013808,248738589.0099999,null,null,0.88059301697560366,271228397.5899995,null,null,0.88854836887920974,337307964.4900009,null,null,0.88946408618387618,367537151.18000084]
["0 to 5","0 to 5",null,null,{"$f":"IFERROR(F119/F$128,0)","v":1.7067110173108906E-3},{"$f":"IFERROR(VLOOKUP($A$119,'[8]Residual '!$A$1:$C$12,3,FALSE),\"\")","v":288567.59999999998},null,null,1.397856710879463E-3,322268.86999999994,null,null,1.3205138028149674E-3,342280.42,null,null,1.2760658614266679E-3,361723.68,null,null,1.2357236798892573E-3,380610.9599999999,null,null,1.0651903414979466E-3,404364.24,null,null,1.0250280374719492E-3,423553.79]
["6 to 10","06 to 10",null,null,2.0257642423651759E-3,{"$f":"IFERROR(VLOOKUP($A$120,'[8]Residual '!$A$1:$C$12,3,FALSE),\"\")","v":342512.54},null,null,2.039783764097958E-3,470261.94,null,null,1.8846164067359266E-3,488497.2,null,null,1.923471564931397E-3,545242.4,null,null,1.8285601736040351E-3,563208.47,null,null,1.56917348150672E-3,595684.75,null,null,1.4952638577633544E-3,617860.82999999996]
["11 to 15","11 to 15",null,null,8.7988136128100483E-3,{"$f":"IFERROR(VLOOKUP($A$121,'[8]Residual '!$A$1:$C$12,3,FALSE),\"\")","v":1487687.43},null,null,8.0960744814756787E-3,1866509.46,null,null,7.6356533251348991E-3,1979180.09,null,null,8.0525097173771848E-3,2282627.8299999996,null,null,8.0052036798417756E-3,2465654.9900000002,null,null,7.6836715665759359E-3,2916851.47,null,null,7.2822098774985031E-3,3009095.83]
["16 to 20","16 to 20",null,null,1.3928195167180239E-2,{"$f":"IFERROR(VLOOKUP($A$122,'[8]Residual '!$A$1:$C$12,3,FALSE),\"\")","v":2354953.9499999997},null,null,1.1255478381915481E-2,2594894.2200000002,null,null,1.4171108275891235E-2,3673186.06,null,null,1.4213417159958639E-2,4029047.1800000006,null,null,1.3655951708664817E-2,4206122.2699999996,null,null,1.2345723169600347E-2,4686644.9799999986,null,null,1.2567920074798575E-2,5193214.22]
["21 to 25","21 to 25",null,null,2.6269984607051381E-2,{"$f":"IFERROR(VLOOKUP($A$123,'[8]Residual '!$A$1:$C$12,3,FALSE),\"\")","v":4441681.3},null,null,2.1698899928320931E-2,5002572.8000000007,null,null,2.1427133677089507E-2,5553965.6600000001,null,null,1.994219143981002E-2,5652970.6600000001,null,null,1.9462590978943959E-2,5994605.0700000003,null,null,1.7301137065576819E-2,6567803.7700000005,null,null,1.802908559850044E-2,7449832.8400000008]
["26 to 30","26 to 30",null,null,4.1351689144830291E-2,{"$f":"IFERROR(VLOOKUP($A$124,'[8]Residual '!$A$1:$C$12,3,FALSE),\"\")","v":6991668.5199999986},null,null,3.5888208717982935E-2,8273846.9399999985,null,null,3.4425629256849784E-2,8923207.629999999,null,null,3.4378169232674172E-2,9745106.6299999971,null,null,3.2574172796550678E-2,10033057.859999999,null,null,3.0854001111663171E-2,11712699.809999999,null,null,2.9749431162150477E-2,12292819.180000002]
["31 to 35","31 to 35",null,null,1.5745571259781824E-2,{"$f":"IFERROR(VLOOKUP($A$125,'[8]Residual '!$A$1:$C$12,3,FALSE),\"\")","v":2662232.5999999996},null,null,1.2999681061436031E-2,2997011.4200000004,null,null,1.3266092620494394E-2,3438603.78,null,null,1.5494441396272094E-2,4392176.3999999994,null,null,1.5240375270847735E-2,4694135.0699999994,null,null,1.3688663195062241E-2,5196447.6899999995,null,null,1.3048979929744369E-2,5391993.8799999999]
["36 to 40","36 to 40",null,null,2.0748605408167094E-2,{"$f":"IFERROR(VLOOKUP($A$126,'[8]Residual '!$A$1:$C$12,3,FALSE),\"\")","v":3508136.53},null,null,2.2135866731726166E-2,5103313.3099999987,null,null,2.0999760449259962E-2,5443189.4700000007,null,null,1.9606913943196205E-2,5557930.2599999988,null,null,1.8640229739445156E-2,5741312.4399999985,null,null,1.9090227608650093E-2,7246972.75,null,null,1.9948867571706691E-2,8243109.6100000003]
["41+ %","41+%",null,null,8.2114250009221439E-3,{"$f":"IFERROR(VLOOKUP($A$127,'[8]Residual '!$A$1:$C$12,3,FALSE),\"\")","v":1388372.83},null,null,7.2843924101177668E-3,1679380.22,null,null,7.5655020992286912E-3,1960996.72,null,null,7.6285978742155185E-3,2162462.4400000004,null,null,8.7641749966088835E-3,2699423.11,null,null,7.8538435806569176E-3,2981451.6400000006,null,null,7.3891277064893849E-3,3053275.55]
[null,null,null,null,{"$f":"SUM(E118:E127)","v":1.0000000000000002},{"$f":"SUM(F118:F127)","v":169078184.34000015},{"$f":"F115-F128","v":0},null,0.99999999999999989,230544996.12999973,2.6822090148925781E-7,null,1,259202455.33999985,0,null,1,283467876.48999989,0,null,1,308006527.82999951,4.76837158203125E-7,null,0.99999999999999989,379616885.59000093,-9.5367431640625E-7,null,0.99999999999999989,413211906.91000086,-8.9406967163085938E-7]
["2004 Q1"]
["2004 Q2","Quarter of Maturity Distribution"]
[{"$f":"RIGHT(B131,2)&LEFT(B131,4)","v":"Q12017"},"2017Q1",null,null,{"$f":"F131/F$160","v":0},{"$f":"IFERROR(VLOOKUP($A$131,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["Q22017","2017Q2",null,null,0,{"$f":"IFERROR(VLOOKUP($A$132,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[{"$f":"RIGHT(B133,2)&LEFT(B133,4)","v":"Q32017"},"2017Q3",null,null,0,{"$f":"IFERROR(VLOOKUP($A$133,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[{"$f":"RIGHT(B134,2)&LEFT(B134,4)","v":"Q42017"},"2017Q4",null,null,0,{"$f":"IFERROR(VLOOKUP($A$134,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,3.9619095367794426E-5,12202.940000000002,null,null,3.2145408866716273E-5,12202.940000000002,null,null,3.9454550382912639E-3,1630309]
["Q12018","2018Q1",null,null,0,{"$f":"IFERROR(VLOOKUP($A$135,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,3.4704637865190475E-5,9837.6499999999942,null,null,2.4331588206261541E-4,74942.879999999976,null,null,1.8026450586791982E-2,6843145.0299999993,null,null,1.99199963078334E-2,8231179.6599999974]
["Q22018","2018Q2",null,null,0,{"$f":"IFERROR(VLOOKUP($A$136,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,7.9711148507499792E-5,22595.550000000003,null,null,3.1524849386826053E-3,970985.94000000006,null,null,7.0949258113584546E-3,2693353.64,null,null,7.1318382184031928E-3,2946960.47]
["Q32018","2018Q3",null,null,0,{"$f":"IFERROR(VLOOKUP($A$137,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":0},null,null,0,0,null,null,4.9499955481401662E-5,12830.510000000002,null,null,4.0299066128584721E-3,1142349.0699999998,null,null,7.376941410975806E-3,2272146.11,null,null,8.4140435561387474E-3,3194113.0099999993,null,null,9.3383244661447949E-3,3858706.8599999985]
["Q42018","2018Q4",null,null,0,{"$f":"IFERROR(VLOOKUP($A$138,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":0},null,null,0,0,null,null,9.014992728116341E-3,2336708.2500000005,null,null,1.3188743522872822E-2,3738585.1200000015,null,null,1.534818902477674E-2,4727342.4099999992,null,null,1.4984152644209572E-2,5688237.3600000003,null,null,2.0316929545373719E-2,8395197.1999999937]
["Q12019","2019Q1",null,null,2.0739227912151356E-4,{"$f":"IFERROR(VLOOKUP($A$139,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":35065.51},null,null,2.7968437477446272E-2,6447983.3099999977,null,null,3.2900706279243214E-2,8527943.8499999959,null,null,3.378611734983613E-2,9577278.9399999958,null,null,3.3718743440827918E-2,10385593.089999998,null,null,4.7134631359167747E-2,17893101.960000008,null,null,4.9365116418203472E-2,20398253.890000004]
["Q22019","2019Q2",null,null,8.9023438823615658E-3,{"$f":"IFERROR(VLOOKUP($A$140,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":1505192.1400000001},null,null,1.7482223763934181E-2,4030439.21,null,null,1.7944387231590486E-2,4651229.2299999986,null,null,1.8090095052378529E-2,5127960.8299999982,null,null,2.3433978171994354E-2,7217818.2499999944,null,null,2.5714554253371564E-2,9761679,null,null,2.5119031340645047E-2,10379482.839999992]
["Q32019","2019Q3",null,null,2.5336277336558483E-2,{"$f":"IFERROR(VLOOKUP($A$141,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":4283811.7699999996},null,null,2.5987994667303733E-2,5991402.1299999999,null,null,2.6245247064024195E-2,6802832.4799999967,null,null,3.1602175283223038E-2,8958201.5200000014,null,null,3.3431298331713669E-2,10297058.120000001,null,null,3.1860044031504497E-2,12094610.690000003,null,null,3.1367834622498203E-2,12961562.760000002]
["Q42019","2019Q4",null,null,3.575942262215092E-2,{"$f":"IFERROR(VLOOKUP($A$142,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":6046138.2499999991},null,null,3.7436323645616131E-2,8630757.089999998,null,null,4.4121916457151432E-2,11436509.080000004,null,null,4.7669237506976145E-2,13512697.529999992,null,null,4.7832118344360117E-2,14732604.690000013,null,null,4.530869601142179E-2,17199946.069999993,null,null,4.9997523509165941E-2,20659572.030000012]
["Q12020","2020Q1",null,null,8.5479408159109371E-2,{"$f":"IFERROR(VLOOKUP($A$143,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":14452703.129999995},null,null,0.11071711556735234,25525276.980000008,null,null,0.11037099981353905,28608434.150000002,null,null,0.10549391257409346,29904135.379999992,null,null,0.10038770865618116,30920069.580000002,null,null,0.11199896886546709,42516699.749999993,null,null,0.11170717038425906,46158732.889999963]
["Q22020","2020Q2",null,null,5.6499524331241696E-2,{"$f":"IFERROR(VLOOKUP($A$144,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":9552836.9899999984},null,null,5.4031392956262324E-2,12456667.280000007,null,null,5.1590092587893759E-2,13372278.669999996,null,null,4.9948686374342972E-2,14158848.060000002,null,null,5.4314033400075803E-2,16729076.840000004,null,null,5.1550595700149533E-2,19569476.590000011,null,null,4.9098395812729748E-2,20288041.760000017]
["Q32020","2020Q3",null,null,3.6017608089249489E-2,{"$f":"IFERROR(VLOOKUP($A$145,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":6089791.7800000003},null,null,2.982484797077431E-2,6875969.4600000018,null,null,2.936142043877291E-2,7610552.2699999977,null,null,3.3136115232201141E-2,9393024.2200000025,null,null,3.4865690268510052E-2,10738860.200000005,null,null,3.0838065150356895E-2,11706650.249999998,null,null,3.0004909497200059E-2,12398385.870000005]
["Q42020","2020Q4",null,null,6.5344639541330907E-2,{"$f":"IFERROR(VLOOKUP($A$146,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":11048353.01},null,null,5.4580601666602738E-2,12583284.6,null,null,5.9770418068293592E-2,15492639.119999997,null,null,5.9896387944328389E-2,16978701.90000001,null,null,5.9664399548515261E-2,18377024.54000001,null,null,5.2675092070579799E-2,19996354.400000006,null,null,5.5899057562808642E-2,23098156.170000013]
["Q12021","2021Q1",null,null,0.2363526746279703,{"$f":"IFERROR(VLOOKUP($A$147,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":39962081.090000004},null,null,0.24615699534853325,56750263.540000021,null,null,0.23810607703944758,61717679.800000004,null,null,0.22829930837783302,64715520.150000006,null,null,0.21545655579945253,66362025.650000043,null,null,0.21534563016854757,81748837.449999973,null,null,0.2103707266328444,86927689.109999955]
["Q22021","2021Q2",null,null,0.11293018945367746,{"$f":"IFERROR(VLOOKUP($A$148,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":19094031.390000001},null,null,0.10254050795650203,23640201.009999994,null,null,9.7045717553116806E-2,25154488.270000011,null,null,9.3089340445709656E-2,26387837.659999993,null,null,9.8381850551962663E-2,30302252.189999998,null,null,9.2325354457107586E-2,35048263.520000003,null,null,8.705164376551873E-2,35970775.720000006]
["Q32021","2021Q3",null,null,8.4847452177223878E-2,{"$f":"IFERROR(VLOOKUP($A$149,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":14345853.159999995},null,null,7.2170881603597137E-2,16638635.61999999,null,null,7.1448074693997915E-2,18519516.389999978,null,null,7.5174308968839185E-2,21309501.730000012,null,null,7.3586580030244417E-2,22665147.010000005,null,null,6.4893856346017437E-2,24634803.639999993,null,null,6.2628960049877266E-2,25879032.009999994]
["Q42021","2021Q4",null,null,0.10686047422692599,{"$f":"IFERROR(VLOOKUP($A$150,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":18067774.960000012},null,null,8.5965377139760171E-2,19818887.539999999,null,null,8.5104676115295305E-2,22059341.009999994,null,null,8.7205394332828534E-2,24719927.949999992,null,null,8.546580783680395E-2,26324026.719999999,null,null,7.4804901488681491E-2,28397203.730000019,null,null,7.4272720671344439E-2,30690372.540000007]
["Q12022","2022Q1",null,null,0.13481097315407803,{"$f":"IFERROR(VLOOKUP($A$151,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":22793594.569999997},null,null,0.12545541610320088,28923118.419999987,null,null,0.11815934316604304,30627191.870000001,null,null,0.11086714649696343,31427274.589999974,null,null,0.10533483870805135,32443817.929999992,null,null,9.9747108986338207E-2,37865686.860000007,null,null,9.570889514230238E-2,39548055.07]
["Q22022","2022Q2",null,null,2.8452175653402218E-3,{"$f":"IFERROR(VLOOKUP($A$152,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":481064.22000000003},null,null,2.6219168498419756E-3,604469.81000000006,null,null,2.365172965648961E-3,613058.64000000013,null,null,2.192861313588485E-3,621605.74,null,null,2.0457725829362331E-3,630111.31000000006,null,null,1.9732146762539383E-3,749065.6100000001,null,null,1.8331725135040352E-3,757488.71000000008]
["Q32022","2022Q3",null,null,4.2364508040824856E-3,{"$f":"IFERROR(VLOOKUP($A$153,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":716291.4099999998},null,null,3.9177052860028165E-3,903207.34999999986,null,null,3.6064047648538752E-3,934788.96999999974,null,null,3.5239089605810718E-3,998914.98999999976,null,null,3.4426008028805208E-3,1060343.5199999998,null,null,2.9589808110200401E-3,1123279.0799999998,null,null,2.7922170699967255E-3,1153777.3399999999]
["Q42022","2022Q4",null,null,3.5699517495776769E-3,{"$f":"IFERROR(VLOOKUP($A$154,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":603600.96},null,null,3.1422619972697476E-3,724432.78,null,null,2.7948530774901418E-3,724432.78,null,null,2.6919378641724829E-3,763077.90999999992,null,null,2.4774731736243267E-3,763077.90999999992,null,null,2.3185876166494368E-3,880175.01,null,null,2.1300814310554399E-3,880175.01]
["Q12023","2023Q1",null,null,0,{"$f":"IFERROR(VLOOKUP($A$155,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["Q22023","2023Q2",null,null,0,{"$f":"IFERROR(VLOOKUP($A$156,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["Q32023","2023Q3",null,null,0,{"$f":"IFERROR(VLOOKUP($A$157,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["Q42023","2023Q4",null,null,0,{"$f":"IFERROR(VLOOKUP($A$158,'[8]Quarter of Maturity Dist'!$A$1:$C$18,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[]
[null,null,null,null,{"$f":"SUM(E131:E158)","v":1},{"$f":"SUM(F131:F159)","v":169078184.34},{"$f":"F128-F160","v":0},null,0.99999999999999989,230544996.13,-2.6822090148925781E-7,null,1,259202455.33999997,0,null,0.99999999999999956,283467876.49000007,0,null,0.99999999999999989,308006527.8300001,-5.9604644775390625E-7,null,1,379616885.58999997,9.5367431640625E-7,null,1.0000000000000002,413211906.90999997,8.9406967163085938E-7]
["0 to 6 months"]
["07 to 12 months","Seasoning Distribution"]
["0 to 6 months","0 to 6 months",null,null,{"$f":"F163/F$174","v":0},{"$f":"IFERROR(VLOOKUP($A$163,'[8]Seasoning Distribution'!$A$1:$C$9,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["07 to 12 months","07 to 12 months",null,null,{"$f":"F164/F$174","v":0},{"$f":"IFERROR(VLOOKUP($A$164,'[8]Seasoning Distribution'!$A$1:$C$9,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,9.6569383295540337E-2,36659368.530000009,null,null,0.23745559658175802,98119479.86999996]
["13 to 18 months","13 to 18 months",null,null,0,{"$f":"IFERROR(VLOOKUP($A$165,'[8]Seasoning Distribution'!$A$1:$C$9,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0.10303418292629836,29206881.039999988,null,null,0.25701312266892057,79161719.520000175,null,null,0.3801154365031259,144298238.17000011,null,null,0.34726202258555344,143492802.5500001]
["19 to 24 months","19 to 24 months",null,null,0,{"$f":"IFERROR(VLOOKUP($A$166,'[8]Seasoning Distribution'!$A$1:$C$9,3,FALSE),0)","v":0},null,null,0.11799719662820338,27203663.240000002,null,null,0.26743405481661975,69319563.649999991,null,null,0.40897799417525776,115932123.53999981,null,null,0.37161684217022461,114460413.24000013,null,null,0.26711926610535164,101402983.88000007,null,null,0.24638760308563651,101810291.31000011]
["25 to 30 months","25 to 30 months",null,null,0.29443570585009299,{"$f":"IFERROR(VLOOKUP($A$167,'[8]Seasoning Distribution'!$A$1:$C$9,3,FALSE),0)","v":49782654.550000049},null,null,0.4078437567865506,94026337.329999998,null,null,0.37168506603699819,96341681.729999959,null,null,0.2634479781790533,74679038.940000042,null,null,0.24083046454437843,74177355.180000007,null,null,0.19244769037724915,73056392.85999997,null,null,0.10226532416744677,42257249.610000007]
["31 to 36 months","31 to 36 months",null,null,{"$f":"F168/F$174","v":0.38984945714493358},{"$f":"IFERROR(VLOOKUP($A$168,'[8]Seasoning Distribution'!$A$1:$C$9,3,FALSE),0)","v":65915038.380000018},null,null,0.27389228354535206,63144495.45000007,null,null,0.24658526963473817,63915507.340000071,null,null,0.18898173032276488,53570249.789999962,null,null,9.6019492276226318E-2,29574630.420000006,null,null,1.8373484517580512E-2,6974884.9700000007,null,null,2.774877685820749E-2,11466125.000000002]
["37 to 42 months","37 to 42 months",null,null,{"$f":"F169/F$174","v":0.22709401168389659},{"$f":"IFERROR(VLOOKUP($A$169,'[8]Seasoning Distribution'!$A$1:$C$9,3,FALSE),0)","v":38396643.169999987},null,null,0.17542689266261272,40443792.289999984,null,null,8.8161941869049548E-2,22851791.79999999,null,null,1.3401977278840002E-2,3799030.040000001,null,null,1.8335534703722362E-2,5647464.379999999,null,null,2.3581882655421618E-2,8952080.8499999978,null,null,1.6001457773674763E-2,6611992.8799999952]
["43 to 48 months","43 to 48 months",null,null,7.6556907684616773E-2,{"$f":"IFERROR(VLOOKUP($A$170,'[8]Seasoning Distribution'!$A$1:$C$9,3,FALSE),0)","v":12944102.950000001},null,null,1.1742617733821726E-2,2707201.76,null,null,1.7398383144498191E-2,4509703.6300000008,null,null,1.8209910639317546E-2,5161924.6999999993,null,null,1.1166181263204419E-2,3439256.72,null,null,3.8129303909924094E-3,1447452.76,null,null,3.8116436231907698E-3,1575016.5300000003]
["49 to 54 months","49 to 54 months",null,null,7.9545228454515546E-3,{"$f":"IFERROR(VLOOKUP($A$171,'[8]Seasoning Distribution'!$A$1:$C$9,3,FALSE),0)","v":1344936.2799999996},null,null,1.1369661428357106E-2,2621218.5499999998,null,null,8.0364285796120805E-3,2083062.0199999996,null,null,1.7946425404500705E-3,508723.51,null,null,1.329172283731463E-3,409393.74,null,null,1.0390775594371786E-2,3944513.87,null,null,1.0102527493016371E-2,4174484.6499999985]
["55 to 60 months","55 to 60 months",null,null,3.7856795215689605E-3,{"$f":"IFERROR(VLOOKUP($A$172,'[8]Seasoning Distribution'!$A$1:$C$9,3,FALSE),0)","v":640075.81999999983},null,null,1.7275912151023787E-3,398287.51,null,null,6.9885591848421736E-4,181145.17,null,null,2.1168793001529731E-3,600067.28000000014,null,null,3.2438674499504641E-3,999132.34999999986,null,null,6.1412308527231986E-3,2331314.9300000016,null,null,8.0088667452673269E-3,3309359.0999999987]
["60+ months","61 to 72 months",null,null,3.2371526943970961E-4,{"$f":"IFERROR(VLOOKUP($A$173,'[8]Seasoning Distribution'!$A$1:$C$9,3,FALSE),0)","v":54733.19},null,null,0,0,null,null,0,0,null,null,3.4704637865190516E-5,9837.6499999999942,null,null,4.4532263964127636E-4,137162.28,null,null,1.4479197076434759E-3,549654.7699999999,null,null,9.5618108624845636E-4,395105.41000000003]
["61 to 72 months","Total",null,null,{"$f":"SUM(E163:E173)","v":1.0000000000000002},{"$f":"SUM(F163:F173)","v":169078184.34000003},{"$f":"F160-F174","v":0},null,0.99999999999999989,230544996.13000005,0,null,1.0000000000000002,259202455.33999997,0,null,0.99999999999999989,283467876.48999977,0,null,0.99999999999999978,308006527.83000034,0,null,0.99999999999999989,379616885.59000015,0,null,1,413211906.91000021,0]
[]
[null,"Remaining Term Distribution"]
["0 - 12 months","0-12 Months",null,null,{"$f":"F177/$Z$183","v":8.0557859280866465E-2},{"$f":"IFERROR(VLOOKUP($A$177,'[8]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":30581123.649999987},null,null,8.4104848340395083E-2,31927620.590000045,null,null,0,0,null,null,5.8073241831002376E-2,22045583.200000018,null,null,5.8709778927144553E-2,22287223.430000015,null,null,6.0144108854681161E-2,22831719.289999992,null,null,4.6395432705126742E-2,19171145.220000006]
["13 - 24 months","13-24 Months",null,null,{"$f":"F178/$Z$183","v":0.19159756096454325},{"$f":"IFERROR(VLOOKUP($A$178,'[8]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":72733669.380000025},null,null,0.17802085875333951,67579723.969999999,null,null,0,0,null,null,0.17760354465058617,67421304.489999995,null,null,0.17801488149024591,67577454.900000051,null,null,0.17110151936221199,64953025.899999961,null,null,0.14721667781768305,60831684.169999935]
["25 - 36 months","25-36 Months",null,null,0.16975930572698844,{"$f":"IFERROR(VLOOKUP($A$179,'[8]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":64443498.939999968},null,null,0.28751388513808346,109145125.64000018,null,null,0,0,null,null,0.31960892401145674,121328944.34000011,null,null,0.3183888919275828,120865799.56,null,null,0.28210926306282574,107093439.83999988,null,null,0.23989998110483046,99129528.659999996]
["37 - 48 months","37-48 Months",null,null,{"$f":"F180/$Z$183","v":3.4769063761445323E-3},{"$f":"IFERROR(VLOOKUP($A$180,'[8]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":1319892.3699999996},null,null,5.7670053048284924E-2,21892525.929999996,null,null,0,0,null,null,0.18726886210425397,71090422.200000033,null,null,0.25144463308487391,95452628.510000065,null,null,0.41056981029114076,155859232.6999999,null,null,0.41707556364666165,172340588.9800002]
["49 - 60 months","49-60 Months",null,null,{"$f":"F181/$Z$183","v":0},{"$f":"IFERROR(VLOOKUP($A$181,'[8]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,4.1663643532132292E-3,1581622.26,null,null,4.8033201346300552E-3,1823421.43,null,null,7.6075298429140167E-2,28879467.859999992,null,null,0.14856291157982202,61387963.990000002]
["60+ Months","60+ Months",null,null,0,{"$f":"IFERROR(VLOOKUP($A$182,'[8]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,8.4943314587604293E-4,350995.89]
[null,null,null,null,{"$f":"SUM(E177:E182)","v":0.44539163234854268},{"$f":"SUM(F177:F182)","v":169078184.33999997},{"$f":"F174-F183","v":0},null,0.60730964528010289,230544996.13000023,0,null,0,0,259202455.33999997,null,0.74672093695051256,283467876.49000013,0,null,0.81136150556447717,308006527.83000016,0,null,0.99999999999999978,379616885.58999979,0,null,1,413211906.91000015,0]
[]
[null,"Origination LVR Distribution"]
["01. 10% to 20%","10% to 20%",null,null,{"$f":"F186/F$202","v":0},{"$f":"IFERROR(VLOOKUP($A$186,'[8]LVR Band'!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0,null,null,9.9781462201329543E-6,2586.3600000000006,null,null,1.8214550671254434E-5,5163.239999999998,null,null,2.509946803551816E-5,7730.7999999999956,null,null,4.703889810445866E-5,17856.759999999995,null,null,4.9383330099547365E-5,20405.779999999995]
["02. 21% to 30%","21% to 30%",null,null,3.0392923960351989E-3,{"$f":"IFERROR(VLOOKUP($A$187,'[8]LVR Band'!$A$1:$C$10,3,FALSE),0)","v":513878.04000000004},null,null,3.8207220923732713E-3,880848.36,null,null,4.2501908732111952E-3,1101659.9099999999,null,null,4.0105949361077115E-3,1136874.83,null,null,3.9572358696005755E-3,1218854.48,null,null,4.4356964189907798E-3,1683865.2599999998,null,null,4.6848657979781669E-3,1935842.3299999998]
["03. 31% to 40%","31% to 40%",null,null,2.4338480958163791E-2,{"$f":"IFERROR(VLOOKUP($A$188,'[8]LVR Band'!$A$1:$C$10,3,FALSE),0)","v":4115106.17},null,null,2.7837398285500619E-2,6417772.879999999,null,null,2.7285663597294538E-2,7072510.9999999972,null,null,2.6094658455103444E-2,7396997.4199999962,null,null,2.632866503555371E-2,8109400.6999999965,null,null,2.9736631294615259E-2,11288527.360000001,null,null,2.9310327043983061E-2,12111376.130000001]
["04. 41% to 50%","41% to 50%",null,null,7.5542543763750913E-2,{"$f":"IFERROR(VLOOKUP($A$189,'[8]LVR Band'!$A$1:$C$10,3,FALSE),0)","v":12772596.140000004},null,null,8.1151370726130823E-2,18709042.449999996,null,null,7.8868635419308331E-2,20442943.949999999,null,null,7.6535840846027436E-2,21695452.279999997,null,null,7.5418953694453228E-2,23229530.060000017,null,null,8.1468769893977139E-2,30926920.700000029,null,null,7.9678887513691815E-2,32924265.050000027]
["05. 51% to 60%","51% to 60%",null,null,0.13753030339644345,{"$f":"IFERROR(VLOOKUP($A$190,'[8]LVR Band'!$A$1:$C$10,3,FALSE),0)","v":23253373.990000013},null,null,0.14320174709575498,33014446.230000019,null,null,0.14659849398477562,37998689.590000041,null,null,0.14823768724807312,42020622.420000032,null,null,0.14588519807216777,44933593.32000006,null,null,0.15014729977412097,56998450.320000052,null,null,0.15017884270095838,62055685.970000029]
["06. 61% to 70%","61% to 70%",null,null,0.17047465841032811,{"$f":"IFERROR(VLOOKUP($A$191,'[8]LVR Band'!$A$1:$C$10,3,FALSE),0)","v":28823545.72000001},null,null,0.17122691189419945,39475507.740000002,null,null,0.17030457524831896,44143364.06000004,null,null,0.17099089579453594,48470426.129999965,null,null,0.17303890110866976,53297111.109999947,null,null,0.17385476588436141,65998204.770000026,null,null,0.17249696714457122,71277800.729999989]
["07. 71% to 80%","71% to 80%",null,null,0.19200179134121376,{"$f":"IFERROR(VLOOKUP($A$192,'[8]LVR Band'!$A$1:$C$10,3,FALSE),0)","v":32463314.269999977},null,null,0.18796577664849642,43334569.249999985,null,null,0.19161034545314196,49665872.009999976,null,null,0.19297069779943707,54700993.929999933,null,null,0.19262844345541605,59330818.029999994,null,null,0.1925829753762815,73107749.329999819,null,null,0.19338513247974848,79909039.359999955]
["08. 81% to 90%","81% to 90%",null,null,0.23413133843686981,{"$f":"IFERROR(VLOOKUP($A$193,'[8]LVR Band'!$A$1:$C$10,3,FALSE),0)","v":39586501.600000031},null,null,0.22426520665339253,51703221.199999951,null,null,0.22403608655569154,58070703.719999976,null,null,0.22675075675556317,64276555.509999998,null,null,0.23031430521873111,70938309.459999993,null,null,0.22169878267979939,84160601.419999883,null,null,0.22286080018516313,92088736.219999865]
["09. 91% to 100%","91% to 100%",null,null,0.16294159129719438,{"$f":"IFERROR(VLOOKUP($A$194,'[8]LVR Band'!$A$1:$C$10,3,FALSE),0)","v":27549868.409999993},null,null,0.16053086660415319,37009588.019999988,null,null,0.15703603072203828,40704124.739999972,null,null,0.15439065361448073,43764790.729999989,null,null,0.15240319807737554,46941179.87000002,null,null,0.1460280397797461,55434709.669999979,null,null,0.14735479380380453,60888755.340000011]
["> 100%","> 100%",null,null,0,{"$f":"IFERROR(VLOOKUP($A$195,'[8]LVR Band'!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,{"$f":"SUM(E186:E195)","v":0.99999999999999956},{"$f":"SUM(F186:F195)","v":169078184.34000003},{"$f":"F183-F196","v":0},null,1.0000000000000013,230544996.12999997,2.6822090148925781E-7,null,1.0000000000000004,259202455.34,-259202455.34,null,1,283467876.48999989,0,null,1.0000000000000031,308006527.83000004,0,null,0.999999999999997,379616885.58999979,0,null,0.99999999999999833,413211906.90999991,0]
[]
[null,"New v Used"]
["New","New",null,null,{"$f":"F199/F$202","v":0.96446714989605742},{"$f":"IFERROR(VLOOKUP($A$199,'[8]New v Used'!$A$1:$C$4,3,FALSE),0)","v":163070354.56000012},null,null,0.95768048470460643,220788443.63999966,null,null,0.95891573412747433,248553312.74999985,null,null,0.95725046636659206,271349756.96999997,null,null,0.95673490693887153,294680596.73999906,null,null,0.95121892997141289,361098767.71000093,null,null,0.94868245610691326,392006886.74000055]
["USed","Used",null,null,{"$f":"F200/F$202","v":3.5532850103942595E-2},{"$f":"IFERROR(VLOOKUP($A$200,'[8]New v Used'!$A$1:$C$4,3,FALSE),0)","v":6007829.7799999984},null,null,4.2319515295393663E-2,9756552.4899999928,null,null,4.1084265872525595E-2,10649142.589999996,null,null,4.2749533633407985E-2,12118119.519999994,null,null,4.3265093061128579E-2,13325931.089999998,null,null,4.8781070028587212E-2,18518117.880000014,null,null,5.1317543893086716E-2,21205020.170000017]
["Used"]
[null,null,null,null,{"$f":"SUM(E199:E200)","v":1},{"$f":"SUM(F199:F200)","v":169078184.34000012},{"$f":"F196-F202","v":0},null,1,230544996.12999964,3.2782554626464844E-7,null,0.99999999999999989,259202455.33999985,0,null,1,283467876.48999995,0,null,1,308006527.82999903,1.0132789611816406E-6,null,1,379616885.59000093,-1.1324882507324219E-6,null,1,413211906.91000056,-6.5565109252929688E-7]
[]
[null,"Contract Type"]
["Finance Lease","Finance Lease",null,null,{"$f":"F205/F$208","v":1.4498960404438425E-2},{"$f":"IFERROR(VLOOKUP($A$205,'[8]Loan Type'!$A$1:$C$4,3,FALSE),0)","v":2451457.8999999994},null,null,1.5182180913726372E-2,3500175.8400000003,null,null,1.5001920506113068E-2,3888534.6300000004,null,null,1.4355641494155554E-2,4069363.2100000004,null,null,1.4645334505669055E-2,4510858.63,null,null,1.3412806077070131E-2,5091727.6700000009,null,null,1.2781233095372302E-2,5281357.7]
["Goods Mortgage","Goods Mortgage",null,null,{"$f":"F206/F$208","v":0.98550103959556157},{"$f":"IFERROR(VLOOKUP($A$206,'[8]Loan Type'!$A$1:$C$4,3,FALSE),0)","v":166626726.43999988},null,null,0.98481781908627364,227044820.2899996,null,null,0.98499807949388696,255313920.70999983,null,null,0.98564435850584453,279398513.27999967,null,null,0.98535466549433093,303495669.19999897,null,null,0.98658719392292982,374525157.92000091,null,null,0.98721876690462773,407930549.21000075]
["Hire Purchase","Hire Purchase",null,null,0,{"$f":"IFERROR(VLOOKUP($A$207,'[8]Loan Type'!$A$1:$C$4,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,{"$f":"SUM(E205:E207)","v":1},{"$f":"SUM(F205:F207)","v":169078184.33999988},{"$f":"F202-F208","v":2.384185791015625E-7},null,1,230544996.12999961,0,null,1,259202455.33999982,0,null,1,283467876.48999965,0,null,1,308006527.82999897,0,null,1,379616885.59000093,0,null,1,413211906.91000074,0]
[]
[null,"Contract by Source"]
["Non Hardship Refinance","Non Hardship Refinance",null,null,{"$f":"F211/F$213","v":0.99820322686107699},{"$f":"VLOOKUP($A$211,'[8]Refinance vs Hardship'!$A$1:$C$4,3,FALSE)","v":168774389.19999987},null,null,0.99827125660200733,230146442.98999968,null,null,0.99816665660293735,258727248.22999981,null,null,0.99780711857831295,282846265.04999954,null,null,0.99746305961271287,307225133.62999916,null,null,0.9964280391060778,378260908.92000097,null,null,0.99587511310420385,411507454.53000069]
["Refinance - Hardship","Hardship Refinance",null,null,{"$f":"F212/F$213","v":1.7967731389230996E-3},{"$f":"VLOOKUP($A$212,'[8]Refinance vs Hardship'!$A$1:$C$4,3,FALSE)","v":303795.14},null,null,1.7287433979927456E-3,398553.14,null,null,1.8333433970625919E-3,475207.11000000004,null,null,2.1928814216870523E-3,621611.43999999994,null,null,2.5369403872871226E-3,781394.2,null,null,3.5719608939221441E-3,1355976.6700000002,null,null,4.1248868957961494E-3,1704452.3800000001]
[null,null,null,null,{"$f":"SUM(E211:E212)","v":1},{"$f":"SUM(F211:F212)","v":169078184.33999985},{"$f":"F208-F213","v":0},null,1,230544996.12999967,0,null,0.99999999999999989,259202455.33999982,0,null,1,283467876.48999953,0,null,1,308006527.82999915,0,null,1,379616885.59000099,0,null,1,413211906.91000068,0]
[]
[null,"Payment Frequency Distribution"]
["6 Consecutive","6 Consecutive",null,null,{"$f":"F216/F$222","v":4.9957339162186075E-3},{"$f":"IFERROR(VLOOKUP($A$216,'[8]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":844669.61999999988},null,null,4.2803949188450346E-3,986823.62999999989,null,null,4.994985476899535E-3,1294712.5,null,null,5.498234294830171E-3,1558572.7999999998,null,null,5.2470315852915835E-3,1616119.9799999997,null,null,4.5548611129682314E-3,1729102.19,null,null,5.3152948965683516E-3,2196343.14]
["Annual","Annual",null,null,0.68985564793769683,{"$f":"IFERROR(VLOOKUP($A$217,'[8]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":116639540.41000006},null,null,0.72866242334435205,167989475.57000002,null,null,0.71834762169116728,186197467.32999995,null,null,0.69792572417629595,197839522.9799999,null,null,0.68382754496765275,210623347.75999975,null,null,0.71273377647437108,270565776.47999978,null,null,0.70689911860071619,292099132.79000026]
["Monthly","Monthly",null,null,0.21453024653411043,{"$f":"IFERROR(VLOOKUP($A$218,'[8]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":36272384.56999997},null,null,0.18783627398957398,43304713.059999943,null,null,0.19736062527994724,51156358.659999989,null,null,0.21245391737403618,60223860.809999906,null,null,0.22538024514959223,69418586.750000045,null,null,0.20620665223660442,78279527.109999925,null,null,0.21179301575416892,87515395.909999833]
["Quarterly","Quarterly",null,null,1.562641987382013E-2,{"$f":"IFERROR(VLOOKUP($A$219,'[8]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":2642086.6999999993},null,null,1.3727528608842247E-2,3164813.0299999993,null,null,1.3832550410438555E-2,3585431.0299999975,null,null,1.3896919039921523E-2,3939330.1300000004,null,null,1.4027610942014504E-2,4320595.7399999993,null,null,1.2500042991040761E-2,4745227.3899999987,null,null,1.2613249528492392E-2,5211944.8900000006]
["Semi Annual","Semi Annual",null,null,5.9175395625732312E-2,{"$f":"IFERROR(VLOOKUP($A$220,'[8]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":10005268.449999997},null,null,5.2330797816132146E-2,12064603.579999994,null,null,5.2284464868294883E-2,13552261.67,null,null,5.6614646247459918E-2,16048433.549999997,null,null,5.6619110130111457E-2,17439055.519999996,null,null,5.0667016958706866E-2,19234055.18,null,null,5.0022900851455998E-2,20670058.25]
["Structured","Structured",null,null,1.5816556112421755E-2,{"$f":"IFERROR(VLOOKUP($A$221,'[8]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":2674234.5899999994},null,null,1.3162581322254613E-2,3034567.2599999993,null,null,1.3179752273252519E-2,3416224.149999999,null,null,1.3610558867456386E-2,3858156.2199999979,null,null,1.4898457225337574E-2,4588822.0799999982,null,null,1.333765022630853E-2,5063197.2399999993,null,null,1.335642036859813E-2,5519031.9299999997]
["0% to 1%",null,null,null,{"$f":"SUM(E216:E221)","v":1.0000000000000002},{"$f":"SUM(F216:F221)","v":169078184.34},{"$f":"F213-F222","v":0},null,1,230544996.12999994,-2.6822090148925781E-7,null,1,259202455.33999994,0,null,1.0000000000000002,283467876.48999977,0,null,1.0000000000000002,308006527.82999974,-5.9604644775390625E-7,null,0.99999999999999989,379616885.58999974,1.2516975402832031E-6,null,1,413211906.91000009,5.9604644775390625E-7]
["1.01% to 2%"]
["2.01% to 3%","Yield Distribution"]
["01. 0% to 1%",null,null,null,{"$f":"F225/F$239","v":0.15047020861567895},{"$f":"IFERROR(VLOOKUP($A$225,'[8]Contract Yield'!$A$1:$C$11,3,FALSE),0)","v":25441229.67000002},null,null,0.14847548320111098,34230279.700000018,null,null,0.15006854298110994,38898134.810000032,null,null,0.14680414925769569,41614260.450000018,null,null,0.14821327746402896,45650656.969999954,null,null,0.14465059438717046,54911808.140000001,null,null,0.14455156250618309,59730426.789999977]
["02. 1.01% to 2%",null,null,null,0.1386543322635729,{"$f":"IFERROR(VLOOKUP($A$226,'[8]Contract Yield'!$A$1:$C$11,3,FALSE),0)","v":23443422.749999989},null,null,0.14518644122349883,33472007.530000012,null,null,0.15306970517681356,39676043.419999994,null,null,0.15620121877041673,44278027.789999969,null,null,0.15819178139916762,48724101.32,null,null,0.15932655357518483,60483050.059999965,null,null,0.16094812670653558,66505682.349999867]
["03. 2.01% to 3%",null,null,null,0.32671931210779631,{"$f":"IFERROR(VLOOKUP($A$227,'[8]Contract Yield'!$A$1:$C$11,3,FALSE),0)","v":55241108.079999983},null,null,0.33458996718585604,77138042.690000013,null,null,0.33216727834257237,86098574.12999998,null,null,0.33321172088200285,94454818.939999953,null,null,0.32813587394414923,101067991.18999998,null,null,0.32678154315290492,124051791.68000001,null,null,0.32269978294464541,133343392.67000003]
["04. 3.01% to 4%",null,null,null,0.30541918628696352,{"$f":"IFERROR(VLOOKUP($A$228,'[8]Contract Yield'!$A$1:$C$11,3,FALSE),0)","v":51639721.480000019},null,null,0.28841263452322491,66492089.709999993,null,null,0.28101324439406067,72839322.930000037,null,null,0.2776398838362783,78701988.300000101,null,null,0.27704436825149892,85331473.920000076,null,null,0.27370546878733776,103903217.63000016,null,null,0.27009869968318456,111607998.75000012]
[null,"< 4%",null,null,{"$f":"SUM(E225:E228)","v":0.92126303927401176},{"$f":"SUM(F225:F228)","v":155765481.98000002},null,null,0.91666452613369076,211332419.63000005,null,null,0.9163187708945566,237512075.29000005,null,null,0.91385697274639366,259049095.48000005,null,null,0.91158530105884472,280774223.40000004,null,null,0.90446415990259799,343349867.51000011,null,null,0.89829817184054861,371187500.56]
["05. 4.01% to 5%","4% to 5%",null,null,{"$f":"F230/F$239","v":5.4077251868364845E-2},{"$f":"IFERROR(VLOOKUP($A$230,'[8]Contract Yield'!$A$1:$C$11,3,FALSE),0)","v":9143283.5600000005},null,null,5.7162244252609608E-2,13178469.379999999,null,null,5.7076826300097624E-2,14794453.519999996,null,null,5.7227020503581687E-2,16222021.979999995,null,null,5.675341254341229E-2,17480421.539999992,null,null,5.7922806399471755E-2,21988475.369999997,null,null,5.9145641186286319E-2,24439683.180000007]
["06. 5.01% to 6%","5% to 6%",null,null,6.2152433449771203E-3,{"$f":"IFERROR(VLOOKUP($A$231,'[8]Contract Yield'!$A$1:$C$11,3,FALSE),0)","v":1050862.0599999998},null,null,7.2245766247765559E-3,1665589.9899999998,null,null,8.2941777198058519E-3,2149871.23,null,null,1.042895331423661E-2,2956273.2500000005,null,null,1.1901020883632606E-2,3665592.1199999982,null,null,1.5511310464623623E-2,5888355.3699999982,null,null,1.8025748182571896E-2,7448453.7800000003]
["07. 6.01% to 7%","6% to 7%",null,null,1.3004433650520474E-2,{"$f":"IFERROR(VLOOKUP($A$232,'[8]Contract Yield'!$A$1:$C$11,3,FALSE),0)","v":2198766.0299999998},null,null,1.3112273225376805E-2,3022968.9799999986,null,null,1.2546997001760722E-2,3252212.4299999983,null,null,1.2796358708842836E-2,3627356.6299999976,null,null,1.3287903470211325E-2,4092761.0099999988,null,null,1.4722876937661767E-2,5589052.6899999985,null,null,1.602393878122722E-2,6621282.3000000007]
["08. 7.01% to 8%","7% to 8%",null,null,5.2085922464667487E-3,{"$f":"IFERROR(VLOOKUP($A$233,'[8]Contract Yield'!$A$1:$C$11,3,FALSE),0)","v":880659.31999999972},null,null,5.6666454788866279E-3,1306416.7599999998,null,null,5.4693674029453717E-3,1417673.4599999997,null,null,5.3683330853670228E-3,1521749.9800000002,null,null,5.6902593667344072E-3,1752637.0299999996,null,null,6.3472860704157034E-3,2409536.9699999997,null,null,7.036970840807173E-3,2907760.1399999983]
["09. 8.01% to 9%","8% to 9%",null,null,2.314396156591707E-4,{"$f":"IFERROR(VLOOKUP($A$234,'[8]Contract Yield'!$A$1:$C$11,3,FALSE),0)","v":39131.390000000014},null,null,1.6973428465970501E-4,39131.390000000014,null,null,2.9386068083378053E-4,76169.41,null,null,3.2236164157818984E-4,91379.169999999984,null,null,7.821026771645483E-4,240892.72999999998,null,null,1.0020389620150772E-3,380390.91000000003,null,null,1.3930428924580184E-3,575621.90999999992]
["10. 9.01% to 10%","9% to 10%",null,null,0,{"$f":"IFERROR(VLOOKUP($A$235,'[8]Contract Yield'!$A$1:$C$11,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,4.7309648325932366E-5,19548.910000000003]
["11. 10.01% to 11%","10% to 11%",null,null,0,{"$f":"IFERROR(VLOOKUP($A$236,'[8]Contract Yield'!$A$1:$C$11,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,2.9521263214049224E-5,11206.770000000004,null,null,2.9176627774731314E-5,12056.129999999997]
["12. 11.01% to 12%","11% to 12%",null,null,0,{"$f":"IFERROR(VLOOKUP($A$237,'[8]Contract Yield'!$A$1:$C$11,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["13. > 12%","> 12%",null,null,0,{"$f":"IFERROR(VLOOKUP($A$238,'[8]Contract Yield'!$A$1:$C$11,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,{"$f":"SUM(E229:E238)","v":1.0000000000000002},{"$f":"SUM(F229:F238)","v":169078184.34},{"$f":"F222-F239","v":0},null,1,230544996.13000003,0,null,1,259202455.34000006,0,null,1,283467876.49000007,0,null,0.99999999999999989,308006527.83000004,0,null,1,379616885.59000015,0,null,0.99999999999999967,413211906.91000003,0]
[]
[null,"Top 5 Obligor",null,null,{"$f":"F241/E13","v":2.9540168588257001E-2},{"$f":"SUM('[8]Top 5 Obligor '!$E$1:$E$6)","v":4994598.0699999994},null,null,3.3665544428574258E-2,7761422.8099999987,null,null,4.0646641237175533E-2,10535709.210000001,null,null,3.7167206882334929E-2,10535709.210000001,null,null,3.4206123111179765E-2,10535709.210000001,null,null,2.7753531547010657E-2,10535709.210000001,null,null,2.8435129780902371E-2,11749734.199999999]

{"sheet":"Note Balance","index":1,"n_rows":152,"n_cols":8,"rows_kept":152,"cut":false,"hidden":false,"merged":[]}
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes"]
[null,null,"Initial Invested Amount",{"$f":"SUM(E3:H3)","v":417600000},122000000,272200000,13500000,9900000]
[null,null,"Invested Amount as at Previous Payment Date:  17 August 2017",{"$f":"SUM(E4:H4)","v":417600000},122000000,272200000,13500000,9900000]
[null,null,"Stated Amount as at Previous Payment Date:  17 August 2017",{"$f":"SUM(E5:H5)","v":417600000},122000000,272200000,13500000,9900000]
[null,null,"Principal Payments to Noteholders on Payment Date",36788093.090000004,36788093.090000004,0,0,0]
[null,null,"Gross Aggregate Charge-Offs",0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
[null,null,"Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
[null,null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 November 2017",{"$f":"SUM(E14:H14)","v":380811906.90999997},85211906.909999996,272200000,13500000,9900000]
[null,null,"Stated Amount as at Payment Date:  16 November 2017",{"$f":"SUM(E15:H15)","v":380811906.90999997},85211906.909999996,272200000,13500000,9900000]
[null,null,"Bond Factor at Payment Date:  16 November 2017",null,0.6984582533606557,1,1,1]
[null,null,"Coupon Margin",null,5.7999999999999996E-3,9.2999999999999992E-3,1.7000000000000001E-2,2.3E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.2749999999999999E-2,2.6249999999999999E-2,3.3950000000000001E-2,3.9949999999999999E-2]
[null,null,"Days in Coupon Period",null,91,91,91,91]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 November 2017",null,691973.97,1781418.49,114267.33,98605.36]
[]
[]
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes"]
[null,null,"Initial Invested Amount",{"$f":"SUM(E25:H25)","v":417600000},122000000,272200000,13500000,9900000]
[null,null,"Invested Amount as at Previous Payment Date:  16 November 2017",{"$f":"SUM(E26:H26)","v":380811906.90999997},85211906.909999996,272200000,13500000,9900000]
[null,null,"Stated Amount as at Previous Payment Date:  16 November 2017",{"$f":"SUM(E27:H27)","v":380811906.90999997},85211906.909999996,272200000,13500000,9900000]
[null,null,"Principal Payments to Noteholders on Payment Date",{"$f":"SUM(E28:H28)","v":33408797.100000001},33408797.100000001,0,0,0]
[null,null,"Gross Aggregate Charge-Offs",0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
[null,null,"Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
[null,null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 February 2018",{"$f":"SUM(E36:H36)","v":347403109.81},51803109.809999995,272200000,13500000,9900000]
[null,null,"Stated Amount as at Payment Date:  16 February 2018",{"$f":"SUM(E37:H37)","v":347403109.81},51803109.809999995,272200000,13500000,9900000]
[null,null,"Bond Factor at Payment Date:  16 February 2018",null,0.42461565418032782,1,1,1]
[null,null,"Coupon Margin",null,5.7999999999999996E-3,9.2999999999999992E-3,1.7000000000000001E-2,2.3E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.3E-2,2.6499999999999999E-2,3.4200000000000001E-2,4.02E-2]
[null,null,"Days in Coupon Period",null,92,92,92,92]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 February 2018",null,493995.6,1818146.85,116373.7,100312.77]
[]
[]
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes"]
[null,null,"Initial Invested Amount",{"$f":"SUM(E47:H47)","v":417600000},122000000,272200000,13500000,9900000]
[null,null,"Invested Amount as at Previous Payment Date:  16 February 2018",{"$f":"SUM(E48:H48)","v":347403109.81},51803109.809999995,272200000,13500000,9900000]
[null,null,"Stated Amount as at Previous Payment Date:  16 February 2018",{"$f":"SUM(E49:H49)","v":347403109.81},51803109.809999995,272200000,13500000,9900000]
[null,null,"Principal Payments to Noteholders on Payment Date",{"$f":"SUM(E50:H50)","v":71610357.760000005},51803109.810000002,19807247.949999999,0,0]
[null,null,"Gross Aggregate Charge-Offs",0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
[null,null,"Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
[null,null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 May 2018",{"$f":"SUM(E58:H58)","v":275792752.05000001},0,252392752.05000001,13500000,9900000]
[null,null,"Stated Amount as at Payment Date:  16 May 2018",{"$f":"SUM(E59:H59)","v":275792752.05000001},-7.4505805969238281E-9,252392752.05000001,13500000,9900000]
[null,null,"Bond Factor at Payment Date:  16 May 2018",null,-6.1070332761670722E-17,0.92723274081557683,1,1]
[null,null,"Coupon Margin",null,5.7999999999999996E-3,9.2999999999999992E-3,1.7000000000000001E-2,2.3E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.3449999999999999E-2,2.6949999999999998E-2,3.465E-2,4.0649999999999999E-2]
[null,null,"Days in Coupon Period",null,89,89,89,89]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 May 2018",null,296207.34000000003,1788726.88,114060.21,98127.99]
[]
[]
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes"]
[null,null,"Initial Invested Amount",{"$f":"SUM(E69:H69)","v":417600000},122000000,272200000,13500000,9900000]
[null,null,"Invested Amount as at Previous Payment Date:  16 May 2018",{"$f":"SUM(E70:H70)","v":275792752.05000001},0,252392752.05000001,13500000,9900000]
[null,null,"Stated Amount as at Previous Payment Date:  16 May 2018",275792752.05000001,-7.4505805969238281E-9,252392752.05000001,13500000,9900000]
[null,null,"Principal Payments to Noteholders on Payment Date",24526448.399999999,0,24526448.399999999,0,0]
[null,null,"Gross Aggregate Charge-Offs",{"$f":"SUM(E73:I73)","v":0},0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
[null,null,"Aggregate Charge-Offs for this Collection Period",-7.4505805969238281E-9,-7.4505805969238281E-9,0,0,0]
[null,null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",{"$f":"SUM(E76:I76)","v":0},0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",-7.4505805969238281E-9,-7.4505805969238281E-9,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 August 2018",{"$f":"SUM(E80:H80)","v":251266303.65000001},0,227866303.65000001,13500000,9900000]
[null,null,"Stated Amount as at Payment Date:  16 August 2018",{"$f":"SUM(E81:H81)","v":251266303.65000001},0,227866303.65000001,13500000,9900000]
[null,null,"Bond Factor at Payment Date:  16 August 2018",null,0,0.83712822795738429,1,1]
[null,null,"Coupon Margin",null,5.7999999999999996E-3,9.2999999999999992E-3,1.7000000000000001E-2,2.3E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.4799999999999999E-2,2.8299999999999999E-2,3.6000000000000004E-2,4.1999999999999996E-2]
[null,null,"Days in Coupon Period",null,92,92,92,92]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 August 2018",null,0,1800355.53,122498.63,104804.38]
[]
[]
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes"]
[null,null,"Initial Invested Amount",{"$f":"SUM(E91:H91)","v":417600000},122000000,272200000,13500000,9900000]
[null,null,"Invested Amount as at Previous Payment Date:  16 August 2018",251266303.65000001,0,227866303.65000001,13500000,9900000]
[null,null,"Stated Amount as at Previous Payment Date:  16 August 2018",251266303.65000001,0,227866303.65000001,13500000,9900000]
[null,null,"Principal Payments to Noteholders on Payment Date",24074875.890000001,0,24074875.890000001,0,0]
[null,null,"Gross Aggregate Charge-Offs",0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
[null,null,"Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
[null,null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 November 2018",227191427.75999999,0,203791427.75999999,13500000,9900000]
[null,null,"Stated Amount as at Payment Date:  16 November 2018",227191427.75999999,0,203791427.75999999,13500000,9900000]
[null,null,"Bond Factor at Payment Date:  16 November 2018",null,0,0.74868268831741358,1,1]
[null,null,"Coupon Margin",null,5.7999999999999996E-3,9.2999999999999992E-3,1.7000000000000001E-2,2.3E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.5350000000000001E-2,2.8850000000000001E-2,3.6549999999999999E-2,4.2550000000000004E-2]
[null,null,"Days in Coupon Period",null,92,92,92,92]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 November 2018",null,0,1656993.82,124370.14,106176.82]
[]
[]
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes"]
[null,null,"Initial Invested Amount",{"$f":"SUM(E113:H113)","v":417600000},122000000,272200000,13500000,9900000]
[null,null,"Invested Amount as at Previous Payment Date:  16 November 2018",227191427.75999999,0,203791427.75999999,13500000,9900000]
[null,null,"Stated Amount as at Previous Payment Date:  16 November 2018",227191427.75999999,0,203791427.75999999,13500000,9900000]
[null,null,"Principal Payments to Noteholders on Payment Date",28657459.210000001,0,28657459.210000001,0,0]
[null,null,"Gross Aggregate Charge-Offs",0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
[null,null,"Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
[null,null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  18 February 2019",198533968.54999998,0,175133968.54999998,13500000,9900000]
[null,null,"Stated Amount as at Payment Date:  18 February 2019",198533968.54999998,0,175133968.54999998,13500000,9900000]
[null,null,"Bond Factor at Payment Date:  18 February 2019",null,0,0.64340179481998527,1,1]
[null,null,"Coupon Margin",null,5.7999999999999996E-3,9.2999999999999992E-3,1.7000000000000001E-2,2.3E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.521E-2,2.8709999999999999E-2,3.6409999999999998E-2,4.2410000000000003E-2]
[null,null,"Days in Coupon Period",null,94,94,94,94]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 18 February 2019",null,0,1506794.73,126587.1,108128.07]
[]
[]
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes"]
[null,null,"Initial Invested Amount",{"$f":"SUM(E135:H135)","v":417600000},122000000,272200000,13500000,9900000]
[null,null,"Invested Amount as at Previous Payment Date:  18 February 2019",{"$f":"SUM(E136:H136)","v":198533968.54999998},0,175133968.54999998,13500000,9900000]
[null,null,"Stated Amount as at Previous Payment Date:  18 February 2019",{"$f":"SUM(E137:H137)","v":198533968.54999998},0,175133968.54999998,13500000,9900000]
[null,null,"Principal Payments to Noteholders on Payment Date",{"$f":"SUM(E138:H138)","v":61466811.789999999},0,61466811.789999999,0,0]
[null,null,"Gross Aggregate Charge-Offs",{"$f":"SUM(E139:H139)","v":0},0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
[null,null,"Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
[null,null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 May 2019",137067156.75999999,0,113667156.75999999,13500000,9900000]
[null,null,"Stated Amount as at Payment Date:  16 May 2019",137067156.75999999,0,113667156.75999999,13500000,9900000]
[null,null,"Bond Factor at Payment Date:  16 May 2019",null,0,0.41758690947832472,1,1]
[null,null,"Coupon Margin",null,5.7999999999999996E-3,9.2999999999999992E-3,1.7000000000000001E-2,2.3E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.53E-2,2.8799999999999999E-2,3.6500000000000005E-2,4.2499999999999996E-2]
[null,null,"Days in Coupon Period",null,87,87,87,87]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 May 2019",null,0,1202234.72,117450,100288.36]

{"sheet":"Cumulative Defaults","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Cumulative Defaults & Losses"]
[]
["Month","Gross Losses","Recoveries","Net Losses"]
["2017-10-01",0,0,0]
["2018-01-01",4.1383160000000002E-4,0,4.1383160000000002E-4]
["2018-04-01",4.1383160000000002E-4,4.850987474747474E-4,0]
["2018-07-01",4.4094924444444445E-4,4.850987474747474E-4,-4.4149503030302959E-5]
["2018-10-01",8.6438315555555556E-4,4.8829874747474743E-4,3.7608440808080813E-4]
["2019-01-01",8.6438315555555556E-4,4.9229874747474742E-4,3.7208440808080814E-4]
["2019-04-01",{"$f":"B9+'Collateral Tables'!E9/450000000","v":8.6438315555555556E-4},{"$f":"C9+'Collateral Tables'!E23/450000000","v":4.9749874747474743E-4},{"$f":"B10-C10","v":3.6688440808080812E-4}]